txtTitle.DataBindings.Add("Text", oDataSet, "ItemRow.Title"); txtCategory.DataBindings.Add("Text", oDataSet, "ItemRow.Category"); txtAuthor.DataBindings.Add("Text", oDataSet, "ItemRow.Author"); txtCatNo.DataBindings.Add("Text", oDataSet, "ItemRow.Catalogue_No"); txtIsbn.DataBindings.Add("Text", oDataSet, "ItemRow.Isbn"); txtPublisher.DataBindings.Add("Text", oDataSet, "ItemRow.Publisher");In SaveChanges I then pass the oDataSet variable to this code in my Data Access class:
public bool UpdateDataSet(DataSet oDataSet, string sTableName) { bool bRetVal = true; try { DataRow oRow = oDataSet.Tables[0].Rows[0]; DataRowState state = oRow.RowState; \\state = Unchanged oAdapter.Update(oDataSet, sTableName); } catch(SqlException e) { oException = e; bRetVal = false; } return bRetVal; }The DataAdapater is stored as oAdapter on the data access class. When I run this, it doesn't error, but it also doesn't save.