473,503 Members | 2,159 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

data adapter update error

5 New Member
hi,

I tried to update record using data table and dataadapter

but I get error for line (in edit case)
daadapter1.update(dtTable1)

the error is
"Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."

can any one help me out from this.


Regards

Mustak
Mar 26 '07 #1
3 949
kenobewan
4,871 Recognized Expert Specialist
Have you tried using fill instead? Please provide more info. Thanks.
Mar 27 '07 #2
channaJ
67 New Member
Have you tried using fill instead? Please provide more info. Thanks.
Fill() and Update() methods of the DataAdapter are used for different purposses. You use Fill() method to get a DataSet or a DataTable filled, where as Update() method is used to Update() the database.
Mar 27 '07 #3
channaJ
67 New Member
hi,

I tried to update record using data table and dataadapter

but I get error for line (in edit case)
daadapter1.update(dtTable1)

the error is
"Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."

can any one help me out from this.


Regards

Mustak
Hi,

I think the problem here is you have not set the Update command of the data adapter properly. Check the UpdateCommand of your DataAdapter and the CommandText of your UpdateCommand.
Mar 27 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
1688
by: Terry Knight | last post by:
hey, i've created a data adpater called 'dabvscores' i've created a dataset called 'dsvbscores' now i've greated a private sub to populate the data adpater and then i fill the dataset and...
2
1179
by: Parveen | last post by:
I have a data grid that's bound to a table in my dataset. After inserting a new row into the grid and populating it with data, I go to save my changes. My data adapter update command returns an...
4
2476
by: Agnes | last post by:
I am confused about these two things 1st)As form load I new a data adapter programmicaly , and I can use stored procedure to 'select sth ' and then fill into the dataset.by using binding context,...
4
1824
by: William | last post by:
After much frustration I was able to update my data store via code only. Using the data adapter was the only way I was able to set up all the objects written in my code. Basically, I cheated by...
1
8048
by: languy | last post by:
Hi there I'm having a problem when using the SqlDataAdapter. When calling the Update(DataSet, string) method I get the following error message "String or binary data would be truncated". The...
6
3784
by: Suresh | last post by:
Hi All, I am fetching a dataset from the database under some condition. After this I create a data table. Traverse in the original dataset & add each row to created data table as it is through...
0
3946
by: mwenz | last post by:
I am trying to update an Access table using OLEDB in VB.Net 2005. I can add rows but I cannot update them. Code to instantiate the Access database and table... Dim conn As New...
9
2714
by: SAL | last post by:
Hello, I have a Dataset that I have table adapters in I designed using the designer (DataLayer). I have a business logic layer that immulates the DataLayer which may/may not have additional logic...
7
1506
by: Kevin | last post by:
I'm new to ADO.NET--trying to make the switch from ADO, which I've been using in my VB2005 apps up until now. Here's what I have: Sub Save_Record() Dim OldRecord as DataTable Dim NewRecord as...
6
2929
by: insirawali | last post by:
Hi all, I have this problem, i need to know is there a way i cn use the data adapter's update method in this scenario. i have 3 tables as below create table table1{ id1 int identity(1,1)...
0
7205
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7349
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7008
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7467
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5594
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5022
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4688
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
1
746
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
399
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.