datarow 转化为datatable

来源:互联网 发布:世界知名软件开发商 编辑:程序博客网 时间:2024/05/17 07:44

        StringBuilder sb = new StringBuilder();
        DataTable mytable = (DataTable)ViewState["table"];
        sb.Append(string.Format(" kp_henly_code like '%{0}%'", TextBox1.Text.Trim()));
        sb.Append(string.Format(" and kp_sup_name like '%{0}%' ", TextBox2.Text.Trim()));
         sb.Append(string.Format(" and  kp_item_name like  '%{0}%' ", TextBox3.Text.Trim()));
         sb.Append(string.Format(" and  kp_branch_no like  '%{0}%' ", TextBox4.Text.Trim()));
         DataRow[] row = mytable.Select(sb.ToString());
        DataTable copytable = mytable.Clone();
         for (int i = 0; i <= row.Length - 1; i++)
         {
            copytable.ImportRow((DataRow)row[i]);
        }

原创粉丝点击