Bind AutoComplete TextBox from Database for Numeric value in Window Application using C# and VB.Net

Hey ArunaAbi,

Please refer below sample.

Namespaces

C#

using System.Data.SqlClient;

VB.Net

Imports System.Data.SqlClient

Code

C#

private void Form1_Load(object sender, EventArgs e)
{
    string constr = @"Server=.\SQL2005;DataBase=Northwind;UID=sa;PWD=pass@123";
    SqlConnection sqlcon = new SqlConnection(constr);
    SqlCommand cmd = new SqlCommand("select OrderID from Orders", sqlcon);
    sqlcon.Open();
    SqlDataReader dr = cmd.ExecuteReader();
    AutoCompleteStringCollection mycollection = new AutoCompleteStringCollection();
    while (dr.Read())
    {
        mycollection.Add(dr.GetInt32(0).ToString());
    }
    txtteacherid.AutoCompleteCustomSource = mycollection;
    sqlcon.Close();
}

VB.Net

Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
    Dim constr As String = "Server=.\SQL2005;DataBase=Northwind;UID=sa;PWD=pass@123"
    Dim sqlcon As SqlConnection = New SqlConnection(constr)
    Dim cmd As SqlCommand = New SqlCommand("select OrderID from Orders", sqlcon)
    sqlcon.Open()
    Dim dr As SqlDataReader = cmd.ExecuteReader()
    Dim mycollection As AutoCompleteStringCollection = New AutoCompleteStringCollection()

    While dr.Read()
        mycollection.Add(dr.GetInt32(0).ToString())
    End While

    txtteacherid.AutoCompleteCustomSource = mycollection
    sqlcon.Close()
End Sub

Screenshot