Yes. I did that, in fact I tested several lines of code for the Update
() method, but still no go. :(
Here's what my method looks like:
public void saveTrimmedResultsEx(ref DataSet ADataSet)
{
//Console.Out.WriteLine(builder.GetUpdateCommand
().CommandText.ToString());
//adapter.Update(ADataSet, "TBL_MFQueryResult"); //
commit changes
to database.
try
{
// adapter.Update(ADataSet.Tables[0]); //no go
// adapter.Update(ADataSet,
"TBL_MFQueryResult"); // no go
//adapter.Update(ADataSet, "TBL_MF");
// adapter.Update(ADataSet); //no go
adapter.Update(ADataSet, "TBL_MF"); // ideal
but no go
}
catch (Exception ex)
{
Console.Out.WriteLine("Error: {0}", ex.Message);
}
}
On Jan 16, 5:21 pm, Usman <[email protected]> wrote:
> have u tried passing table name as an argument to the adapter's update
> function, if not try this coz sometimes just
> dataset doesn't work with this approach.
