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

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

ASP.NET AJAX PasswordStrength Extender

  AJAX Password Strength Extender shows the strength of user chosen passwords.the strength can be show in a  text form, a bar indicator or combination of both.Now i am going to show you how to add ajax password extender control to a asp.net page, In case of Visual studio 2005 install AjaxControlToolkit and in case of Visual studio 2010 add AjaxControlToolkit.dll in the project. I have added a text box and a label control in the page and page will be look like this:                                               After that Add password strength code in the aspx file of the web page. <body>     <form id="form1" runat="server">         <asp:ScriptManager ID="ScriptManager1" runat="ser...
4 comments
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