سلام، لینک های زیر رو ببینید
آموزش اول
آموزش دوم
using System;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace AutoCompleteTextBox
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\NORTHWND.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True";
using (SqlConnection SqlConnection1 = new SqlConnection(ConnectionString))
{
SqlCommand SqlCommand1 = new SqlCommand("SELECT FirstName FROM Employees", SqlConnection1);
SqlConnection1.Open();
SqlDataReader reader = SqlCommand1.ExecuteReader();
AutoCompleteStringCollection MyCollection = new AutoCompleteStringCollection();
while (reader.Read())
{
MyCollection.Add(reader.GetString(0));
}
textBox1.AutoCompleteCustomSource = MyCollection;
SqlConnection1.Close();
}
}
}
}