how to save record from datagrid back to sql server?

[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

 

[William Ryan]

jayPee:

Avoid pulling down joined tables, they are nothing but headaches.. join
them locally using a DataRelation
http://www.knowdotnet.com/articles/datarelation.html

 

[Paul Deibel]

Jay,

Do your tables have primary keys (unique indexes?)

If not, most wizards will not work right.

Hope that helps.

P.D.

 

[jaYPee]

Jay,

Do your tables have primary keys (unique indexes?)

If not, most wizards will not work right.

Hope that helps.

P.D.

Yah the tables have primary keys

 

[Dennis Redfield]

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