Link ListBox With DataBase in Windows Forms

Here I will explain how to connect a ListBox with a database. It is the same as linking a combo box with a database.

Step 1: Form

Drag and drop a List Box from the Toolbox.

Step 2: Code

Now make a function for filling the list box from the database and call this method in the constructor.

void fillListBox()

{

string str = "server = MUNESH\\SQL2008R2;Database=datastore;UID=sa;Password=123;";

SqlConnection con = new SqlConnection(str);

string query = "select * from tablename";

SqlCommand cmd = new SqlCommand( query,con);

SqlDataReader dbr;

try

{

con.Open();

dbr = cmd.ExecuteReader();

while(dbr.Read())

{

string sname = (string) myreader["name"];; //name is coming from database

Listbox1.items.Add(sname);

}

catch(Exception es)

{

messagebox.show(es.Message);

}

public Form2()

{

InitializeComponent();

FillListBox();

}

Step 3: Run

Now run your application.

Adding String on Form

You can also go to my blog_munesh .