Inserting list box selected values in database

Question

How to insert multiple selected values in list box to different rows (one in each row) in database?

Pravin Ghadge · Answer

hi private void button1_Click(object sender EventArgs e) { for(int i=0;i { if(listbox1.Items[i].Selected==true) { str = insert into emp1 values(' + listBox1.Items[i].ToString() + '); com = new OleDbCommand(str con); com.ExecuteNonQuery(); } } MessageBox.Show(Records Added Successfuly ); }

Vulpes · Answer

I'd try using the ListBox.SelectedItems property instead: private void button1_Click(object sender EventArgs e) { for(int i = 0; i { str = insert into emp1 values(' + listBox1.SelectedItems[i].ToString() + '); com = new OleDbCommand(str con); com.ExecuteNonQuery(); } MessageBox.Show(Records Added Successfuly); }

Ankita Ankita · Answer

I tried d code u suggested but its showing an error near  listbox1.Items[i].Selected  after items[i]. in intellisence its not showing any option like selected. Is there any other solution?

Satyapriya Nayak · Answer

Hi shubhangi using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Datagridview_bind { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[dsn]; OleDbCommand com; OleDbDataAdapter oledbda; string str; DataSet ds; DataTable dt; public Form1() { InitializeComponent(); } private void Form1_Load(object sender EventArgs e) { //listBox1.Items.Add(a); //listBox1.Items.Add(b); //listBox1.Items.Add(c); OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select * from emp; com = new OleDbCommand(str con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds emp); dt = ds.Tables[emp]; int i; for (i = 0; i { listBox1.Items.Add(dt.Rows[i].ItemArray[0]); } con.Close(); } private void button1_Click(object sender EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = insert into emp1 values(' + listBox1.SelectedItem + '); com = new OleDbCommand(str con); com.ExecuteNonQuery(); con.Close(); MessageBox.Show(Records Successfuly Inserted); } } } Thanks