[nilesh7136]

Hello,

can i add multiple value in database from the ListBox in one click??
i have one list box and some text box, i want to insert all the item of listbox to database one by one, so how to write that code???

Thank You in adv,,
@Nilesh

[CharlieMay]

One option would be to set up your connection to the database and create an INSERT statement (with a parameter would be preferable)
Create a loop to get the items(index) of the list and use that to fill your parameter. then inside the loop, execute the statement with ExecuteNonQuery.

define connection
create INSERT Statement
Build a Command
Open Database
For x as integer = 0 to listbox.items.count -1
  yourcommand.Parameters.AddWithValue("@parm", listbox.items(x).ToString)
  yourcommand.executenonquery
Next
Close Database

[andrewsw]

You need to clear the parameters each time within the loop:

yourcommand.Parameters.Clear()

[CharlieMay]

good catch andrewsw

[nilesh7136]

CharlieMay, on 18 March 2013 - 11:47 AM, said:

One option would be to set up your connection to the database and create an INSERT statement (with a parameter would be preferable)
Create a loop to get the items(index) of the list and use that to fill your parameter. then inside the loop, execute the statement with ExecuteNonQuery.

define connection
create INSERT Statement
Build a Command
Open Database
For x as integer = 0 to listbox.items.count -1
  yourcommand.Parameters.AddWithValue("@parm", listbox.items(x).ToString)
  yourcommand.executenonquery
Next
Close Database

thanks its done,,,

 Dim j As Integer
            For j = 0 To ListBoxSizeOfPriceListing.Items.Count - 1
                Dim cmd As New SqlCommand("INSERT INTO tblHosePriceList VALUES('" & txtidofPrice.Text & "','" & txtBrandOfPrice.Text & "','" & ListBoxSizeOfPriceListing.Items(j) & "','" & ListBoxPriceOfPriceListing.Items(j) & "')", conn)
                conn.Open()
                cmd.ExecuteNonQuery()
                conn.Close()
                txtidofPrice.Text = txtidofPrice.Text + 1
                RefreshPriceList()
            Next

Thank u so mch,,
@nilesh

[andrewsw]

You don't need to keep opening and closing the connection within the loop; refer back to CharlieMay 's code-outline.

You should also store txtBrandOfPrice.Text as a variable - once - as it doesn't change, rather than reading it again each time.

You are also using txtBrandOfPrice.Text as though it were a variable. Store its value once, and update it once when the loop has finished.