public partial class Autocomplete : Form
{
SqlConnection connection;
SqlConnectionStringBuilder builder;
SqlCommand command;
SqlParameter param;
SqlDataReader reader;
string[] suggestionsList;
int dbRecords;
public Autocomplete()
{
InitializeComponent();
string keyword = comboBox1.text;
connection = new SqlConnection();
try
{
builder = new SqlConnectionStringBuilder();
builder.DataSource = @".SQLEXPRESS";
builder.AttachDBFilename = @"Your path goes here ...";
builder.IntegratedSecurity = true;
builder.UserInstance = true;
connection.ConnectionString = builder.ConnectionString;
connection.Open();
SqlCommand command = new SqlCommand();
command.CommandText =
"SELECT *
FROM keywordsList
WHERE item LIKE '%' + @keywordParam + '%'";
command.Connection = connection;
param = new SqlParameter("@keywordParam", keyword);
command.Parameters.Add(param);
reader = command.ExecuteReader();
while (reader.Read()) dbRecords++;
suggestionsList = new string[dbRecords];
reader.Close();
reader = command.ExecuteReader();
int index = 0;
while (reader.Read())
{
string result = reader.GetString(0);
suggestionsList[index] = result;
index++;
}
reader.Close();
}
catch (SqlException e)
{
errorLabel.Text = e.Message;
}
finally
{
connection.Close();
}
comboBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
comboBox1.AutoCompleteSource = AutoCompleteSource.CustomSource;
comboBox1.AutoCompleteCustomSource.AddRange(sugges tionsList);
}
}
از این راه هم میشه