-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: kvivek23
Message 6 in Discussion
Hi, If its still not solved, here is one more thing you can do... It seems like
you select query is missing the key column information, i.e the PK in the table
you are trying to update. include the pk column also in the select list and
try.
Dim oDataAdapter As New OracleDataAdapter("select ECUFAMILY,MEMDEF,MEMTYPE from
MEMDEF", oConn)
if you include the key column information and use the CommandBuilder, you dont
have the create all insert, update and delete commands...
Here is how you can use command builder...Dim cn As SqlConnection Dim da As
SqlDataAdapter Dim cb As SqlCommandBuilder cn = New SqlConnection("data
source=demoserver…") da = New SqlDataAdapter("SELECT Au_ID, au_lname, City
FROM authors", cn) cb = New SqlCommandBuilder(da) ' Build new
CommandBuilder and then get the commands likecb.GetUpdateCommand Thanks Vivek
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
