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

0
144

ValueMemberSQLfig.3Now, in this tutorial, I will show you how to get the value member in a ComboBox by using C# and SQL Server. This method is very important in selecting the exact data that has been listed in the ComboBox. For example, when you want to display the list of books in the ComboBox that came from the database but you only want to get its id. That’s where you use the value member to get the id of a book that is listed in the ComboBox.

 

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.

ValueMemberSQLfig.1

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

ValueMemberSQLfig.2

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.

After that, create a method for filling data in the list control of a ComboBox.
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.
Go back to the design view again, double-click a ComboBox and do the following codes for getting the value member of a ComboBox when selected.

Output:

ValueMemberSQLfig.3

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

 

Download Source Code

Facebook Comments

LEAVE A REPLY

Please enter your comment!
Please enter your name here