narges_j
پنج شنبه 24 مرداد 1392, 22:42 عصر
AutoComplete کردن یک سلول با پرد کردن لیست از طریق جستجو در جدول
private void GridKharidK_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
if (listname.Count>0)
{
string headr = GridKharidK.Columns[0].HeaderText;
if (headr.Equals("نام کالا"))
{
TextBox tb = e.Control as TextBox;
if (tb != null)
{
tb.AutoCompleteMode = AutoCompleteMode.Suggest;
tb.AutoCompleteCustomSource = listname;
tb.AutoCompleteSource = AutoCompleteSource.CustomSource;
}
}
}
}
public void AutoComplete(string name)
{
DataTable dt = new DataTable();
ClassBusKala Kala = new ClassBusKala();
Kala.Name = name;
dt = Kala.Search();
for (int i = 0; i < dt.Rows.Count; i++)
{
listname.Add(dt.Rows[i]["NameK"].ToString());
}
}
private void GridKharidK_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
AutoComplete (((Control)sender).Text);
}
متغییر listname به صورت سراسری از نوع AutoCompleteStringCollection تعریف شد
private void GridKharidK_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
if (listname.Count>0)
{
string headr = GridKharidK.Columns[0].HeaderText;
if (headr.Equals("نام کالا"))
{
TextBox tb = e.Control as TextBox;
if (tb != null)
{
tb.AutoCompleteMode = AutoCompleteMode.Suggest;
tb.AutoCompleteCustomSource = listname;
tb.AutoCompleteSource = AutoCompleteSource.CustomSource;
}
}
}
}
public void AutoComplete(string name)
{
DataTable dt = new DataTable();
ClassBusKala Kala = new ClassBusKala();
Kala.Name = name;
dt = Kala.Search();
for (int i = 0; i < dt.Rows.Count; i++)
{
listname.Add(dt.Rows[i]["NameK"].ToString());
}
}
private void GridKharidK_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
AutoComplete (((Control)sender).Text);
}
متغییر listname به صورت سراسری از نوع AutoCompleteStringCollection تعریف شد