Insert multiple record into table using ado.net ?

[Jeff]

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!
************************************************** *************
"Jeff" <No*************@hotmail.comNoSpam> wrote in message
news:FC**********************************@microsof t.com...

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 listItem
for each Item in ListBox1.Items
INSERT INTO TABLE....
next Item

[Jeff]

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