سلام
این متد رو ایجاد کنید :
private void getData(AutoCompleteStringCollection dataCollection) // تکست باکس اتوکمپلت
{
string connetionString = null;
SqlConnection connection;
SqlCommand command;
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet ds = new DataSet();
connetionString = "Data Source=.;Initial Catalog=RGF;Integrated Security=True";
string sql = "SELECT DISTINCT [Soft] FROM [Tsoft]";
connection = new SqlConnection(connetionString);
try
{
connection.Open();
command = new SqlCommand(sql, connection);
adapter.SelectCommand = command;
adapter.Fill(ds);
adapter.Dispose();
command.Dispose();
connection.Close();
foreach (DataRow row in ds.Tables[0].Rows)
{
dataCollection.Add(row[0].ToString());
}
}
catch
{
}
}
و در رویداد (text changed) تکست باکس :
{
textBox8.AutoCompleteMode = AutoCompleteMode.Suggest;
textBox8.AutoCompleteSource = AutoCompleteSource.CustomSource;
AutoCompleteStringCollection DataCollection = new AutoCompleteStringCollection();
getData(DataCollection);
textBox8.AutoCompleteCustomSource = DataCollection;
}
catch
{
}