how to read data from chekedlistbox using c sharp window application

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 WindowsFormsApplication1 { public partial class Form2 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; string str; OleDbCommand com; public Form2() { InitializeComponent(); } private void Form2_Load(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from student"; com = new OleDbCommand(str, con); OleDbDataReader reader = com.ExecuteReader(); while (reader.Read()) { checkedListBox1.Items.Add(reader["sname"].ToString()); } } } }

1 Reply

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

Satyapriya Nayak14y ago
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 WindowsFormsApplication1 { public partial class Form2 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; string str; OleDbCommand com; public Form2() { InitializeComponent(); } private void Form2_Load(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from student"; com = new OleDbCommand(str, con); OleDbDataReader reader = com.ExecuteReader(); while (reader.Read()) { checkedListBox1.Items.Add(reader["sname"].ToString()); } } } }