AutoComplete TextBox Search From DataBase Table in Using Windows Application C#

AutoComplete TextBox Search DataBase Table in Windows Application

Window Application Search TextBox Related Keyword Display Database Particular Table Record Display In Window Application.


 Auto Suggestion Box Master Page
 Auto Suggestion Box Multiple Table Search
 Auto Suggestion Ajax AutoCompleteExtender
 Auto Complete Search For WINDOW APPLICATION


                                     DEMO




                    C# Coding


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;


namespace WindowsFormsApplication2
{
    public partial class Form1 : Form
    {
      

        public Form1()
        {
            InitializeComponent();
        }


        SqlConnection con;


        public void dbcon()
        {

    con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Drizzle\Documents\Visual Studio 2012\WindowsFormsApplication2\WindowsFormsApplication2\Database1.mdf;Integrated Security=True");

            con.Open();
       
        }

        private void Form1_Load(object sender, EventArgs e)
        {
          
           
          AutoCompleteStringCollection LocalDataTable = new AutoCompleteStringCollection();

            txtAutoComplete.AutoCompleteMode = AutoCompleteMode.SuggestAppend;

            txtAutoComplete.AutoCompleteSource = AutoCompleteSource.CustomSource;

            txtAutoComplete.AutoCompleteCustomSource = LocalDataTable;

            dbcon();

            SqlCommand cmd = new SqlCommand("select countryname from country",con);     
            
            SqlDataReader rd = cmd.ExecuteReader();         

            if (rd.HasRows == true)
            {

               while (rd.Read())
               {

                   LocalDataTable.Add(rd[0].ToString());

               }
           }             
           
         }

       }
}



AutoCompleteMode :  Get & set control Automatic for Textbox

AutoCompleteSource: Get & set the source of complete String

AutoCompleteCustomSource: Get & set the AutoComplete Source 

Property is set to CustomSource

AutoCompleteStringCollection: Get data from Database To allow Bind 



to TextBox.



First - Add the New Window Form - Add the TextBox & Button 






Next - Insert The Values To DataBase Particular Table








Next - Add the  DataBase Connection - To Window Form Publically.







Path - Assign To SqlConnection








Next - Add the Coding For Form _Load  Geting Refresh








Next - Run[F5] The Program 







Textbox  Enter - A - Related CountryName Display From DataBase 






Textbox  Enter - U - Related CountryName Display From DataBase 








Textbox  Enter - I - Related CountryName Display From DataBase 












0 comments:

Post a Comment