Auto-Suggest in a TextBox with SQL Server and C#

Searching an accurate information or record in the database is very difficult without a hard copy for your basis. So, in this tutorial, I will teach you how to create a  TextBox that has an auto-suggest with C# and SQL server. With this, TextBox will automatically suggest when you begin to type into it. This is very helpful in searching of records when you only knew is the initial letter of it.

autosuggestSQLPI

Let’s begin;

 

autosuggestSQLPIfig.1

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

autosuggestSQLPIfig.2

  • Declare all the classes and variables that are needed.

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

  • Go back to the design view, double click the Form and do the following code for making an auto-suggest TextBox and retrieving data in the SQL database.

 

 

Output:

autosuggestSQLPI

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

ABOUT PROJECTPROJECT DETAILS
Project Name : Auto-Suggest in a TextBox with SQL Server and C#
Project Platform :C#
Programming Language Used:C# Programming Language
Developer Name :itsourcecode.com
IDE Tool (Recommended):Visual Studio 2019
Project Type :Desktop Application
Database:MySQL Database
Upload Date and Time:June 12, 2016- 10:47 am

Leave a Comment