This tutorial will teach you how make a Autocomplete Textbox using C#.net Sqlserver Database.
First Step you have to make the GUI Design after that select the textbox and go to the Properties do the couple of option i attached the screenshot image below.do the same what i attached below.
Write the code inside the Form_Load Event
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | using System.Data.SqlClient; namespace autocomplete { public partial class Form1 : Form { public Form1() { InitializeComponent(); } SqlConnection con = new SqlConnection("server=.; database = Bank; Integrated Security = true"); private void Form1_Load(object sender, EventArgs e) { try { AutoCompleteStringCollection col = new AutoCompleteStringCollection(); con.Open(); string sql = "select * from account"; SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader sdr = null; sdr = cmd.ExecuteReader(); while (sdr.Read()) { col.Add(sdr["accountno"].ToString()); } sdr.Close(); textBox1.AutoCompleteCustomSource = col; con.Close(); } catch(Exception ex) { Console.WriteLine(ex.Message); } } |
I have attached the video tutorial below it will help you to do this step by step.
