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 { } }