Unable to update data adapter - C#
was following d msdn guide in Updating d data adapter wit dataset. When
i try d debug d code line by line, everythings seems fine until d last
statement which is update d data adapter failed(I highlight with red
color in my code). D exception tat is displayed
An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dllAdditional information: Update unable to find TableMapping['Table'] or DataTable 'Table'.This is my code:
string cString = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=white";
SqlConnection myConnection = new SqlConnection(cString);
myConnection.Open();
SqlDataAdapter myAdapter = new SqlDataAdapter("SELECT * FROM Suppliers",
myConnection);
myAdapter.UpdateCommand = new SqlCommand("UPDATE Suppliers SET " +
"CompanyName = @CompanyName, " +
"ContactName = @ContactName, ContactTitle = @ContactTitle, " +
"Address = @Address, City= @City, Region = @Region, " +
"PostalCode = @PostalCode, Country = @Country, Phone = @Phone, " +
"Fax =@Fax, HomePage = @Homepage " +
"WHERE SupplierID = @SupplierID ", myConnection);
myAdapter.UpdateCommand.Parameters.Add("@CompanyName", SqlDbType.NVarChar, 40);
myAdapter.UpdateCommand.Parameters.Add("@ContactName", SqlDbType.NVarChar, 30);
myAdapter.UpdateCommand.Parameters.Add("@ContactTitle", SqlDbType.NVarChar, 30);
myAdapter.UpdateCommand.Parameters.Add("@Address", SqlDbType.NVarChar, 60);
myAdapter.UpdateCommand.Parameters.Add("@City", SqlDbType.NVarChar, 15);
myAdapter.UpdateCommand.Parameters.Add("@Region", SqlDbType.NVarChar, 15);
myAdapter.UpdateCommand.Parameters.Add("@PostalCode", SqlDbType.NVarChar, 10);
myAdapter.UpdateCommand.Parameters.Add("@Country", SqlDbType.NVarChar, 15);
myAdapter.UpdateCommand.Parameters.Add("@Phone", SqlDbType.NVarChar, 24);
myAdapter.UpdateCommand.Parameters.Add("@Fax", SqlDbType.NVarChar, 24);
myAdapter.UpdateCommand.Parameters.Add("@Homepage", SqlDbType.NText, 16);
SqlParameter myParam = myAdapter.UpdateCommand.Parameters.Add("@SupplierID", SqlDbType.Int, 4);
myParam.SourceColumn = "SupplierID";
myParam.SourceVersion = DataRowVersion.Original;
DataSet myDataSet = new DataSet();
myAdapter.Fill(myDataSet, "Suppliers");
DataRow cRow = myDataSet.Tables["Suppliers"].Rows[0];
cRow["Region"] = "Europe";
myAdapter.Update(myDataSet);
