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
"jaYPee" <hi******@yahoo.com> wrote in message
news:bo********************************@4ax.com...

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

[Paul Deibel]

Jay,

Do your tables have primary keys (unique indexes?)

If not, most wizards will not work right.

Hope that helps.

P.D.

-----Original Message-----
anyone know how can i save record from datagrid back to sql serverusing datacommand? im trying to use dataset but no luck. the sourcehas a join table and when i use the dataadapter wizard it says in theupdate statement and delete statement that "Could not determine whichcolumns uniquely identify..."

now i read from msdn that a datacommand can update directly to thedatabase and i want to know how can i save record from datagrid.
thanks in advance
.

[jaYPee]

On Wed, 14 Jan 2004 09:21:47 -0800, "Paul Deibel"
<an*******@discussions.microsoft.com> wrote:

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

-----Original Message-----
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
.

[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

"William Ryan" <do********@nospam.comcast.net> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

jayPee:

Avoid pulling down joined tables, they are nothing but headaches.. join
them locally using a DataRelation
http://www.knowdotnet.com/articles/datarelation.html
"jaYPee" <hi******@yahoo.com> wrote in message
news:bo********************************@4ax.com...

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