inserting 10-12 items from listbox into sql database

Question

hi guys...I am developing windws form & in that form 1 is combox  1 listbox & 1 button .... listbox containg items after selecting items from combobox now i want when i clicking on save button how should i am inserting the all items from listbox into sql database...here following is my code private void Btn_Save_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(ConnectionString); con.Open(); str = insert into Customer_Entery_Form values('+Lst_Bx_Service_Name.Items.ToString()+ '); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); MessageBox.Show(Records successfully Inserted); Lst_Bx_Staff_Name.Items.Clear(); } now the problem is that data is inserting successfully from listbox but when i am showing in sql database it shows like  System.Windows.Forms.ListBox+ObjectCollection

anurag guhe · Answer

hey vinay are you getting my problem plz give me reply fast

anurag guhe · Answer

Error 2 'object' does not contain a definition for 'Selected' and no extension method 'Selected' accepting a first argument of type 'object' could be found (are you missing a using directive or an assembly reference?) E:\company\salon\main_login\main_login\entery_level.cs 92 50 main_login Error 3 'object' does not contain a definition for 'Text' and no extension method 'Text' accepting a first argument of type 'object' could be found (are you missing a using directive or an assembly reference?) E:\company\salon\main_login\main_login\entery_level.cs 94 72 main_login It gives this type of above error actually in my form other controls are also present now below is my full coading private void Btn_Save_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(ConnectionString); con.Open(); str = insert into Customer_Entery_Form values(' + Txt_Bill_No.Text.ToString() + '' + dateTimePicker_Bill_Date.Value.Date.ToString(yyyyMMdd) + ' + int.Parse(Txt_Mobile_No.Text.ToString()) + ' + dateTimePicker_D_O_B.Value.Date.ToString(yyyyMMdd) + '' + Combo_Gender.SelectedItem.ToString() + '' + Txt_First_Name.Text.ToString() + '' + Txt_Middle_Name.Text.ToString() + '' + Txt_Last_Name.Text.ToString() + ' + int.Parse(Txt_Amt_Services_Customer.Text.ToString()) + '+Txt_Amt_Words.Text.ToString()+'); for (int i = 0; i { if (Lst_Bx_Service_Name.Items[i].Selected) { string selectedItem = Lst_Bx_Service_Name.Items[i].Text; str = str + insert into Customer_Entery_Form values(' + selectedItem + ');; } } com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); MessageBox.Show(Records successfully Inserted); Txt_Bill_No.Text = ; Txt_First_Name.Text = ; Txt_Middle_Name.Text = ; Txt_Last_Name.Text = ; Txt_Amt_Services_Customer.Text = ; Txt_Amt_Words.Text = ; Lst_Bx_Staff_Name.Items.Clear(); Lst_Bx_Service_Price.Items.Clear(); Lst_Bx_Service_Name.Items.Clear(); Txt_Mobile_No.Text = ; Combo_Gender.Text=; Combo_Services_Customer.Text = ; Combo_Staff.Text = ; //dateTimePicker_Bill_Date.Text = ; //dateTimePicker_D_O_B.Date=; autogenerated(); }

Vinay Singh · Answer

Hi Prepare multiple insert sql query and insert it. have a look. SqlConnection con = new SqlConnection(ConnectionString); con.Open(); string srt=; for (int i = 0; i < Lst_Bx_Service_Name.Items.Count; i++) { if (Lst_Bx_Service_Name.Items[i].Selected) { string selectedItem = Lst_Bx_Service_Name.Items[i].Text; str =str + insert into Customer_Entery_Form values('+selectedItem + ');; } } com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); MessageBox.Show(Records successfully Inserted); Lst_Bx_Staff_Name.Items.Clear();