I have an existing dataset that I already have from an execution of a stored procedure. I have converted that to a DataTable.
dtblTestTable = dsTestDataSet.Tables;
And I get the row DataRow from that DataTable.
datarowTESTRow = dtblTestTable.Rows;
Now I do some work with that information then I need to update it or basically update the SQL Server table that this table which is from the dataset. And I get the row DataRow from that DataTable.
I have something like this:
datarowTESTRow["TESTFIELD"] = "'Y'";
That doesn't update the table in the SQL Server database.
I want/need to use the existing Dataset or DataTable (which was from the DataSet) already pulled.
How can I perform that aspect?
Any help would be greatly appreciated.