By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,041 Members | 1,018 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,041 IT Pros & Developers. It's quick & easy.

how to save record from datagrid back to sql server?

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 20 '05 #2

P: n/a
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
.

Nov 20 '05 #3

P: n/a
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
.


Nov 20 '05 #4

P: n/a
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


Nov 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.