Yes. The primary key is "ID" as indicated above.
On Jan 16, 7:18 pm, "Muhammad Arif" <[email protected]> wrote: > there must be a primary key in the table you are update through adapter.. > > > > On Fri, Jan 16, 2009 at 1:29 PM, Benj Nunez <[email protected]> wrote: > > > 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. > > -- > Muhammad Arif > Software Engineer > +923009347315
