将两个数据表合并到一个数据集中 [英] Merging two datatable in one dataset

问题描述

DataSet ds = new DataSet();
        DataTable dt1 = new DataTable("Employee");
        dt1.Columns.Add("Empno");
        dt1.Columns.Add("Empname");
        dt1.Rows.Add("1", "Anbu");
        dt1.Rows.Add("2", "Selvan");

        dt1 = DataBindGrid();
        DataTable dt = new DataTable("Attend");
   
       
        
        dt.Columns.Add("Attendence");
        
        RadioButton chk;
        foreach (GridViewRow rowItem in gridview1.Rows)
        {
           
            chk = (RadioButton)(rowItem.Cells[0].FindControl("rb1"));
            if (chk.Checked)
            {
                
                
            }
            else
            {
                dt.Rows.Add("0");
                
            }

            
        }
        dt1.Merge(dt, false, MissingSchemaAction.Add);
        
        ds.Tables.Add(dt1);

我想要的结果是:
1安布1
2 selvan 0

但结果显示为:
1安布
2 selvan
1
0

I want result as:
1 anbu 1
2 selvan 0

But result is coming out as:
1 anbu
2 selvan
1
0

推荐答案

看看此处 [

Hi
Have a look Here[^]
it might be helpful.

这篇关于将两个数据表合并到一个数据集中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！