public void SelectFG1(string Nane)
{
string SetText = "卫材代码 like '%" + Nane + "%' or 卫材名称 like '%" + Nane + "%'";
DataRow[] DR = TabSelect.Select(SetText);
if (DR.Count() != 0)
{
int CellIndex = FG1.ColumnCount;
foreach (DataRow DDr in DR)
{
this.FG1.Rows.Add(DDr.ItemArray);
}
}
else
{
return;
}
}
方法:Table.select(""); 查询语句(where 后面的部分)
public DataTable ToDataTable(DataRow[] rows)
{
if (rows == null || rows.Length == 0) return null;
DataTable tmp = rows[0].Table.Clone(); // 复制DataRow的表结构
foreach (DataRow row in rows)
tmp.Rows.Add(row); // 将DataRow添加到DataTable中
return tmp;
}
datarows转换成datatable
首先得复制表结构--然后foreach填充