Save and Fill Data in a ComboBox in C# and SQL Server

0
157

SaveFillCBOSQLOutput Fill

In this tutorial, I will show you how to save and fill data in the ComboBox in C# and SQL Server 2005. This method is use for displaying data in the database to the list control of a ComboBox. This process has the capability to control whatever data you want to place into the ComboBox.

 

 

To start with:

 

Create a database and name it “categorydb”.

 

After creating the database, open Microsoft Visual Studio 2008 and create new Windows Form Application. Then do the following design of a Form as shown below.

SaveFillCBOSQLfig.1

Go to the Solution Explorer, double click the “View Code”  to display the code editor.

SaveFillCBOSQLfig.2

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

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

 

After declaring the classes and variables, establish a connection between SQL server to C#.net in the first load of the Form.

After that, create a method for filling data into a ComboBox from the database.

Go back to the design view, double click the button and do the following codes for saving data in the SQL database.

Output:

SaveFillCBOSQLOutput

 

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

 

Email – [email protected]

Mobile No. – 09305235027 – tnt

 

Download Sourcecode

Facebook Comments

LEAVE A REPLY

Please enter your comment!
Please enter your name here