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 Initializ...
Post a Comment
Read more

ASP.NET MVC 5 (Part 2)

Before you start this tutorial, you should have the knowledge about, how to create an ASP .NET MVC   web application. MVC stands for the model- View- controller. MVC is an architectural pattern for developing applications that are well architectured, testable and easy to maintain. MVC application contains: Model : classes represent the data of the application. A model does not depend on the controller and view classes. View : Display the model data and send user action (button click) to the controller. Controller : provides the model data to the view and interprets user actions like button click. the controller depends on the model and the view. Controller Let 's start by adding a controller class in MVCProject .In Solution Explorer, right click on the controller folder and select controller.   In the Add scaffold dialogue box,  select MVC 5 controller-empty and then click Add. Name your controller FirstTest, and click the A...
Post a Comment
Read more

Azure App Deployment

I will use the same web application which we created in my previous article ASP.NET MVC5 . Launch the publish wizard In the solution explorer right click the project  MVCProject  and select Publish. The publish wizard is automatically launched. Select the App Service  > Publish to open the Create App Service dialog. Sign in to Azure In the Create App Service dialog, Select Add an account and Sign in to your Azure subscription. if you already have an account then don't select Create . Once you select the Azure account you will see the following details on the dialog box Create a resource group A resource group is a logical container into which web apps, databases, and storage accounts are deployed and managed.we can delete the whole storage group with a single step. In dialog Next to Resource Group select New Enter MVCGroup name and click OK Create an App Service plan An...
Post a Comment
Read more