Insert multiple record into table using ado.net ?

[Guest]

I need to insert into a table multiple item of a listbox. (item.text and item.value
Right now, I'm using an OleDBConnection with Access, a Command(Insert string) and parameters. I don't see how an ExecuteNonQuery() would fit in a loop ? Must be a simple solution out there

dim Item as listIte
for each Item in ListBox1.Item
INSERT INTO TABLE...
next Item

 

[Cowboy \(Gregory A. Beamer\) [MVP]]

The hard thing about a listbox is you have to loop through all of the
choices. Other than that it is very simple. The ExecuteNonQuery() will allow
an insert without the overhead of expecting a reply. This has to be worth
something in terms of performance.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************************************************
Think outside the box!
***************************************************************

I need to insert into a table multiple item of a listbox. (item.text and item.value)
Right now, I'm using an OleDBConnection with Access, a Command(Insert

string) and parameters. I don't see how an ExecuteNonQuery() would fit in a
loop ? Must be a simple solution out there ?

 

[Guest]

But how exactly do I code it... in the for next loop, do I include the parameters ? thank's