INSERT Fails To Update Any Rows...

Hello,

I seem to have a strange problem in that my code runs fine, but I am trying to INSERT rows into a database, and the rows affected by the INSERT command is alwsy zero, even though no error is thrown. Hence no data gets inserted.

Here is the code:



void recordTick(string pair, DateTime time, decimal sell, decimal buy)

{

SqlConnection thisConnection = new SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\FOREX.mdf;Integrated Security=True;User Instance=True");

insert = "INSERT INTO " + pair + " VALUES(" +

"'" + time.ToString("yyyy-MM-dd HH:mms") + "'," +

"'" + sell.ToString() + "'," +

"'" + buy.ToString() + "'" + ")";

thisConnection.Open();

SqlCommand command = new SqlCommand(insert, thisConnection);

Int32 success = command.ExecuteNonQuery(); // success always = 0!

thisConnection.Close();

}


The database is type .MDF that I created with the Project/Add Component/SQL Database menu. I can inspect it easily in Server Exporer and add data manually with no problem.

Can any one suggest how to get the INSERT to actually add the data?

Any help much appreciated!

Anding