View Single Post
Old November 20th, 2007, 03:30 PM
gbianchi gbianchi is offline
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi

hi there.. lately I'm seeing a lot of error of the same kind around here.. you are not building a string, you are just throwing data into it hoping that the compiler understand what are you trying to do..

your command text should be:
cmd.CommandText = "INSERT INTO testtbl(ID, OrderNr, Place) VALUES " + (ds.Tables[0].rows[i]["ID"].ToString() + "," + ds.Tables[1].rows[i]["OrderNr"].ToString() & "," + ds.Tables[2].rows[i]["Place"].ToString() + ")" ;
also, what's the idea behind passing parameters to a command that will never use them???



================================================== =========
Read this if you want to know how to get a correct reply for your question:
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
================================================== =========
I know that CVS was evil, and now i got the proof:
================================================== =========