regarding list box control?

Question

Hai friends, Im storing the list box selected items to database .how can i select the item in list box when item is present in database. thanks and regards sree

Satyapriya Nayak · Answer

Hi Sree, Try this... 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 Form1 : Form { OleDbDataAdapter oledbda; string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; string str; OleDbCommand com; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { listBox1.Items.Add("Raj"); listBox1.Items.Add("Raju"); listBox1.Items.Add("Rahul"); listBox1.Items.Add("Harry"); listBox1.Items.Add("Ben"); listBox1.Items.Add("Ian"); } private void btn_insert_Click(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select count(*)from student where sname='" + listBox1.SelectedItem + "'"; com = new OleDbCommand(str, con); int count = Convert.ToInt32(com.ExecuteScalar()); con.Close(); if (count > 0) { lblMessage.Text = "Sorry! you can't take this student name"; } else { lblMessage.Text = "You can take this student name"; con.Open(); str = "insert into student(sname) values('" + listBox1.SelectedItem + "')"; com = new OleDbCommand(str, con); com.ExecuteNonQuery(); con.Close(); } } } } Thanks If this post helps you mark it as answer

sree · Answer

thank u

regarding list box control?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)