update datatable with adapter.update()

[hamid_m]

i fill a datatable with dataadapter and bind it to an bindingsource one of my function return max(id) from above datatable: datarow[] rows = ds.tables[0].select("id=max(id)"); also datatble has updated whenever needed by: datable dt=ds.tables[0].getchanges(); adapter.update(dt); ds.acceptchanges(); my function (select last id) work correctly for first update, but it dosn't work after add one new record, and return same record. why? :confused:

[RepliCrux]

Try to update the dataset instead of the datatable, and avoind performing dataset acceptchanges. If your Datatable is bound to the control, once you update the adapter, may be the call the binding again. Ofcourse your best friend is debugging.

[hamid_m]

thanks but your solution dos not fix it. i don't have problem with update dataset or datatable, because both has update as well. but select function dosnt work probably :sigh: