I have a C# test app that writes to an access database with the following code
Expand|Select|Wrap|Line Numbers
- DataRow editRow1 = ds.Tables["TraderNames"].Rows.Find("1");
- DataRow editRow2 = ds.Tables["TraderNames"].Rows.Find("2");
- editRow2["TraderName"] = "Bob";
- editRow1["TraderName"] = "AAAAAAA";
- update.Parameters.Clear();
- update.Parameters.Add("@TName", OleDbType.Char, 20, "TraderName");
- update.Parameters.Add("@TNum", OleDbType.Char, 20, "TraderNum");
- update.Parameters.Add("@ID", OleDbType.Char, 20, "TraderID");
- int numRows = adapter.Update(ds.Tables["TraderNames"]);
Expand|Select|Wrap|Line Numbers
- UPDATE Traders SET TraderName = [@TName], TraderNum = [@TNum]
- WHERE TraderID=[@ID];
Before I do the update the database holds this information
Expand|Select|Wrap|Line Numbers
- TraderID TraderName TraderNum
- 1 David 20
- 2 Hamish 11
Expand|Select|Wrap|Line Numbers
- TraderID TraderName TraderNum
- 1 AAAAAAA 20
- 2 BobAAAA 11
Expand|Select|Wrap|Line Numbers
- TraderID TraderName TraderNum
- 1 AAAAAAA 20
- 2 Bob 11
Anyone seen anything like this before?
Thanks