private void txtdm_TextChanged(object sender, System.EventArgs e)
{
try
{
if (txtdm.Text.ToString().Trim() != "")
{
string ssql = "select code,name 名称,pym 拼音码,wbm 五笔码,RECORDID 工号 from vi_ss_vCALIBRATECODE where typeid=" + TypeID + " and ( upper(name) like '%" + txtdm.Text.ToString().Trim().ToUpper() + "%' or left(upper(wbm)," + txtdm.Text.Length + ")='" + txtdm.Text.ToString().Trim().ToUpper() + "' or left(upper(pym)," + txtdm.Text.Length + ")='" + txtdm.Text.ToString().Trim().ToUpper() + "')";
Tb = PubFunction.ExecsqlTable(ssql);
Tb.TableName = "Tb";
// GrdSel.TableStyles[0].MappingName=Tb.TableName ;
// GrdSel.SetDataBinding(Tb,null);
// GrdSel.Refresh();
this.dataGridTableStyle1.MappingName = "dataGridTableStyle1";
this.GrdSel.TableStyles[0].MappingName = "Tb";
this.GrdSel.TableStyles[0].GridColumnStyles[0].MappingName = Tb.Columns["CODE"].ColumnName.Trim();
this.GrdSel.TableStyles[0].GridColumnStyles[1].MappingName = Tb.Columns["名称"].ColumnName.Trim();
this.GrdSel.TableStyles[0].GridColumnStyles[2].MappingName = Tb.Columns["拼音码"].ColumnName.Trim();
this.GrdSel.TableStyles[0].GridColumnStyles[3].MappingName = Tb.Columns["五笔码"].ColumnName.Trim();
this.GrdSel.TableStyles[0].GridColumnStyles[4].MappingName = Tb.Columns["工号"].ColumnName.Trim();
this.GrdSel.SetDataBinding(Tb, null);
this.GrdSel.Refresh();
if (Tb.Rows.Count > 0)
{
this.GrdSel.CurrentRowIndex = 0;
this.GrdSel.Select(this.GrdSel.CurrentRowIndex);
}
}
}
catch
{
}
}
