C#

//Create temporary DataSet variable.<br />
DataSet dsChanges;<br />
// GetChanges for modified rows only.<br />
dsChanges = ds.GetChanges(DataRowState.Modified);<br />
// Check the DataSet for errors.<br />
if(!dsChanges.HasErrors)<br />
{<br />
  // No errors were found, update the DBMS with the SqlDataAdapter da<br />
  // used to create the DataSet.<br />
  da.RowUpdating += new SqlRowUpdatingEventHandler(OnRowUpdating);<br />
  da.RowUpdated += new SqlRowUpdatedEventHandler(OnRowUpdated);<br />
  int res = da.Update(dsChanges); // returns the number of rows updated<br />
  da.RowUpdating -= new SqlRowUpdatingEventHandler(OnRowUpdating);<br />
  da.RowUpdated -= new SqlRowUpdatedEventHandler(OnRowUpdated);<br />
}

public static bool SubmitChanges(ref DataTable tbl, string ConnectionString, string spUpDateName, string spInsertName, string spDeleteName)<br />
		{<br />
			try<br />
			{<br />
				SqlDataAdapter adapter1 = new SqlDataAdapter();<br />
				if (spUpDateName != "")<br />
				{<br />
					adapter1.UpdateCommand = DAHandler.CreateUpdateViaSPCommand(spUpDateName, ConnectionString);<br />
				}<br />
				if (spInsertName != "")<br />
				{<br />
					adapter1.InsertCommand = DAHandler.CreateInsertViaSPCommand(spInsertName, ConnectionString);<br />
				}<br />
				if (spDeleteName != "")<br />
				{<br />
					adapter1.DeleteCommand = DAHandler.CreateDeleteViaSPCommand(spDeleteName, ConnectionString);<br />
				}<br />
				adapter1.ContinueUpdateOnError = true;<br />
				adapter1.Update(tbl);<br />
				adapter1.RowUpdated+=new SqlRowUpdatedEventHandler(adapter1_RowUpdated);<br />
			<br />
			}<br />
			catch<br />
			{<br />
				throw;<br />
<br />
			}<br />
			return true;<br />
		}

<br />
Code generation for property 'Items' failed.  Error was: ''StudioListBoxItemTypeConverter' is unable to convert 'StudioControls.Controls.StudioListBoxItem' to 'System.ComponentModel.Design.Serialization.InstanceDescriptor'.'<br />