User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 427,488 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,436 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 5234 | Replies: 2
Reply
Join Date: Aug 2006
Posts: 14
Reputation: vbgaya is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 0
vbgaya vbgaya is offline Offline
Newbie Poster

How to Update a Data Table?

  #1  
Aug 2nd, 2006
I have written some coding to add a new row to
an existing data table. After clicking the submit
button I get following error.
"Update requires a valid InsertCommand when
passed DataRow collection with new rows."
Please tell me what the additional code I should
add. The "add" method is called after a user
clicking the submit button. I didn't include the
HTML stuff here.
Here is the code,
<script runat="server">
sub add(obj as object, e as EventArgs)
dim objConn as new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\scms\database\scms.mdb")
dim objCmd as new OleDbDataAdapter("select * from services", objConn)
dim ds as DataSet = new DataSet()
objCmd.Fill(ds, "services")
dim dr as DataRow = ds.Tables("services").NewRow()
dr(1)=txtServiceName.text
dr(2)=txtSinhalaShortTag.Text
dr(3)=txtTamilShortTag.Text
dr(4)=txtEnglishShortTag.Text
ds.Tables("services").Rows.Add(dr)
objCmd.Update(ds, "services")
end sub
</script>
Please help me. I can't figure out what to do.
vbgaya.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Jun 2005
Location: Denmark, EU
Posts: 102
Reputation: madmital is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 3
madmital madmital is offline Offline
Junior Poster

Solution Re: How to Update a Data Table?

  #2  
Aug 6th, 2006
There's no need to use DataSet for a simple operation like this.

This should do it:
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\scms\database\scms.mdb") : conn.Open()
Dim insCom As New OleDbCommand("INSERT INTO services (col1, col2, col3, col3) VALUES('" & txtServiceName.text & "', '" & txtSinhalaShortTag.Text & "', '" & txtTamilShortTag.Text & "', '" & txtEnglishShortTag.Text & "'", conn)
insCom.ExecuteNonQuery()
Web Programmer
Reply With Quote  
Join Date: Sep 2005
Location: Austraila
Posts: 1
Reputation: Phillip is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
Phillip Phillip is offline Offline
Newbie Poster

Re: How to Update a Data Table?

  #3  
Oct 6th, 2007
OK - But that does NOT answer the question
Why is the Update command giving an error
Last edited by Phillip : Oct 6th, 2007 at 5:31 pm.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb ASP.NET Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the ASP.NET Forum

All times are GMT -4. The time now is 6:58 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC