Skip to main content

Auto Complete property of Text box

Last week i learned about auto-complete property of  text box.so i want to share it with all of you so that it can help you as well.
First declare following global variables.

 AutoCompleteStringCollection collection = new AutoCompleteStringCollection();
  private string strConnection =System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
        SqlConnection conn = new SqlConnection();

After that i have made a function


 public void  AutoComplete()
        {
            SqlDataReader dReader;


            conn.ConnectionString = strConnection;
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "Select * from test";
            conn.Open();
            dReader = cmd.ExecuteReader();
            if (dReader.HasRows == true)
            {
                while (dReader.Read())
                    namesCollection.Add(dReader["Name"].ToString());


            }
            else
            {
                MessageBox.Show("Data not found");
            }
            dReader.Close();
            conn.Close();
            textword.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
            textword.AutoCompleteSource = AutoCompleteSource.CustomSource;
            textword.AutoCompleteCustomSource =collection;


        }


Now call this function on the Form Load event.
  private void Formname_Load(object sender, EventArgs e)
        {
            AutoComplete();
        }

After that output will look like this.


Hope this post will help you.

Happy programming.....:)



Comments

Post a Comment

Popular posts from this blog

Introduction of Arrays

An array is a linear data structure which stores collection of data in a contagious memory location. The idea is to store the collection of the same type of data. this makes it easier to calculate the position of each item by simply adding an offset to a base value. In the above image of an array, we can identify each element by its index. we can declare an array by specifying the types of its element. type [] arrayname; Types of Arrays single dimensional arrays Multidimensional arrays Single Dimensional Arrays A single dimensional array can be declared in the following way. int [] array = new int [ 5 ]; this array will contain the element from array[0] to array[4].the new operator will initialize  each  element of this array with zero. An array which contains string value can be declared the same way. string[] array = new string[6]; Array Initialization we can also initialize an array while declaration. For example int

How to upload a file on the server through upload control in asp.net

With ASP.NET upload a file on the server is very easy.With FileUpload control we can easily upload a file on the server.Following markup is required.   < form id ="form1" runat ="server" > < asp:FileUpload id ="FileUploadControl" runat ="server" /> < asp:Button runat ="server" id ="btnupload" text ="Upload" onclick =" btnupload _Click" /> < asp:Label runat ="server" id ="lblstatus" /> </ form > Here is the CodeBehind code required to handle upload a file on the server. protected void btnupload _Click( object sender, EventArgs e) { if (FileUploadControl.HasFile) { try { string filename = Path.GetFileName(FileUploadControl.FileName); FileUploadControl.SaveAs(Server.MapPath( " ~/ " ) + filename); lblstatus .Text = " Upload status: Fi

ASP.NET MVC 5 (Part 1)

This tutorial teaches you the basics of building an ASP.NET MVC 5 web app using  Visual Studio 2017 . Get started Start by installing Visual Studio 2017. You can  Install Visual Studio 2017 community version which is free. Open Visual Studio,  Instead of selecting  New Project  on the  Start page , you can use the menu bar and select  File  >  New Project . Your first app On the  Start page , select  New Project . In the  New Project  dialog box, select the  Visual C#  category on the left, then  Web , and then select the  ASP.NET Web Application (.NET Framework)  project template. Name your project "MVCProject" and then choose  OK . In the  New ASP.NET Web Application  dialog, choose  MVC  and then choose  OK . The visual studio used the default template for the project you just created.you have a running application which is doing nothing right now. Press  F5  to start debugging. When you press  F5 , Visual Studio starts  IIS Ex