inserting 10-12 items from listbox into sql database

anurag guhe

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 "

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

anurag guhe10y ago
hey vinay are you getting my problem plz give me reply fast
anurag guhe10y ago
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 < 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");
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 Singh10y ago
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();