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.

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;