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
Default

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:
Code:
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???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========