How to Get Value Member in a ListBox Using C# and SQL Server

How to Get Value Member in a ListBox Using C# and SQL Server

In this tutorial, I’m going to teach you how to get the value member in a Listbox using C# and SQL Server. Listbox is a control window that contained a list of items where it allows the user to choose one or more items. For instance, if you want to display the list of Books in the Listbox from the database but it’s the id that you only want to display. It’s the time to use the value member for getting the id of the employees in the ListBox.

Database : Click here for the database of this project.

Let’s begin:

Open Microsoft Visual Studio and create a new windows application for C#. Then, do the form just like this.

After setting up the form, go to the solution explorer and hit “code view” to fire the code editor.

In the code editor, declare all the classes and variable that are needed.

Note: Put “using System.Data.SqlClient;” above the namespace to access sql server library.

 //initializes new instance 
 SqlConnection con = new SqlConnection();
 SqlDataAdapter da = new SqlDataAdapter();
 SqlCommand cmd = new SqlCommand();
 DataTable dt = new DataTable();
 //declare a variable
 string query;

After that, create a method for filling data in the list control of a ListBox.

 //a method for filling data in the ListBox
 private void LoadBooks(string query, ListBox lst)
 {
 //opening connection
 con.Open();
 try
 {
 //initialize a new instance of sqlcommand
 cmd = new SqlCommand();
 //set a connection used by this instance of sqlcommand
 cmd.Connection = con;
 //set the sql statement to execute at the data source
 cmd.CommandText = query;
 //initialize a new instance of sqlDataAdapter
 da = new SqlDataAdapter();
 //set the sql statement or stored procedure to execute at the data source
 da.SelectCommand = cmd;
 //initialize a new instance of DataTable
 dt = new DataTable();
 //add or resfresh rows in the certain range in the datatable to match those in the data source.
 da.Fill(dt);

 //Get and set the data source of a comboBox
 lst.DataSource = dt;
 //set the field of a table to display in the list control of a combo box
 lst.DisplayMember = "BooksName";
 //'SET THE ACTUAL VALUE OF THE 
 //' ITEMS IN THE LISTBOX
 lst.ValueMember = "ID";
 
 }
 catch (Exception ex)
 {
 //catching error 
 MessageBox.Show(ex.Message);
 }
 //release all resources used by the component
 da.Dispose();
 //closing connection
 con.Close();
 }

Go back to the design view, double-click the form and do the following codes to establish the connection between SQL Server 2005 Express Edition and C#.net.

  //set a connection between SQL server and Visual C#
 con.ConnectionString = "Data Source=.\\SQLEXPRESS;Database=dbbooks;trusted_connection=true;";
 //set up a retrieve query
 query = "Select * From tblbooks";
 LoadBooks(query, listBox1 );//call a load method

Go back to the design view again, click a ListBox and go to properties. In the properties, hit the events, just like a lightning symbol and select click for the events.

after that, do the following codes for getting the value member of a ListBox when selected.

 MessageBox.Show("Book Id : " + listBox1.SelectedValue.ToString());

Output:

For all students who need a programmer for your thesis system or anyone who needs a source code in any a programming languages. You can contact me @ :

Email – [email protected]
Mobile No. – 09305235027 – TNT