Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
C# - DataSet Not Saving
Message
From
15/04/2008 14:07:49
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Miscellaneous
Thread ID:
01310720
Message ID:
01310823
Views:
13
>I'm pretty sure I remember Bonnie posting an example in C# in an earlier thread to you (maybe 2-3 weeks ago). I would check that out. Basically, you will loop through all the records in your DataTable, check their version, and handle it based on that.
>
>Ok, looking back on Bonnies examples, I now have this. Again, it compiles and doesn't error, but the data doesn't
>make it to the back end. The new row is in the data set. What am I doing wrong here???
>
>
>
>/*****************************************************
> * Get the customer record
>******************************************************/
>
>string sSelectCommand = "select * from Customers where CustomerKey = 1";
>
>SqlDataAdapter oDataAdapter = new SqlDataAdapter(sSelectCommand, oConnection);
>DSCustomer oDataSet = new DSCustomer();
>oDataAdapter.Fill(oDataSet, "DSCustomer");
>
>/*****************************************************
> * Or Create a new blank data set record
>******************************************************/
>//DSCustomer oDataSet = new DSCustomer();
>
>// Add a blank row
>oDataSet.Tables[0].Rows.Add();
>
>
>// Get a reference to the table
>DataTable oTable = oDataSet.Tables[0];
>
>// Get the number of rows
>int iRowCount = oTable.Rows.Count - 1;
>
>// Get a reference to the new row
>DataRow oRow = oTable.Rows[iRowCount];
>
>// Edit the column values
>oRow["CustomerName"] = "Someone Else";
>oRow["CreditLimit"] = 15;
>
>// Save the changes to the dataset
>oDataSet.AcceptChanges();
>
>// Create a command builder.
>SqlCommandBuilder oBuilder = new SqlCommandBuilder(oDataAdapter);
>
>// Update the changes to the backend
>oDataAdapter.Update(oDataSet, oDataSet.Tables[0].TableName);
>
>
Your DataSet.AcceptChanges line is marking your DataSet as current, so there are no records to update. Remove that line.
Very fitting: http://xkcd.com/386/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform