how to save record from datagrid back to sql server?

  • Thread starter Thread starter jaYPee
  • Start date Start date
J

jaYPee

anyone know how can i save record from datagrid back to sql server
using datacommand? im trying to use dataset but no luck. the source
has a join table and when i use the dataadapter wizard it says in the
update statement and delete statement that "Could not determine which
columns uniquely identify..."

now i read from msdn that a datacommand can update directly to the
database and i want to know how can i save record from datagrid.

thanks in advance
 
Jay,

Do your tables have primary keys (unique indexes?)

If not, most wizards will not work right.

Hope that helps.

P.D.
 
This does not seem reasonable to me. If you are doing your joins on the
client then you are putting biz logic onto the client. There has gotta' be
a way.

dlr
 
Back
Top