创建DATARABLE

有时候我们会用到datatable来定义一张表格,那么如何在其中加入数据,怎么加呢?

下面就一步一步来讲解这个问题,

.............................................................................................................................................................

        DataTable dt = new DataTable();

此处则是定义了一张表格dt

        DataRow dr;

声明一个为行类型的dr,即dr为一个行

    

         dt.Columns.Add("tCId", typeof(string));
         dt.Columns.Add("tCData", typeof(string));
         dt.Columns.Add("aName", typeof(string));
         dt.Columns.Add("aData", typeof(string));
          dt.Columns.Add("teacherID", typeof(string));
          dt.Columns.Add("aC", typeof(string));
          dt.Columns.Add("aS", typeof(string));

给每个列加对应的列名,

 

          dt.Columns[0].AllowDBNull = true;
          dt.Columns[1].AllowDBNull = true;
          dt.Columns[2].AllowDBNull = true;
          dt.Columns[3].AllowDBNull = true;
           dt.Columns[4].AllowDBNull = true;
           dt.Columns[5].AllowDBNull = true;
           dt.Columns[6].AllowDBNull = true;

对行的数据进行可空说明,即行中数据可以为空

 

                BLL.Syllabus syll = new BLL.Syllabus();
                List<Model.Syllabus> syllabus = syll.GetList(TextBox1.Text,"tCId");
                Model.Syllabus[] sylla = new Model.Syllabus[syllabus.Count];
                syllabus.CopyTo(sylla);

定义一个数组实体sylla

 

 

            for (int i = 0; i < sylla.Length; i++)
                {

                    dr = dt.Rows.Add();    ////////每一次增加一行,这个必须加,否则就不会增加行,
                    dr[0] = sylla[i].TCId;
                    dr[1] = sylla[i].TCData;
                    dr[2]= sylla[i].AName;
                    dr[3] = sylla[i].AData;
                    dr[4] = sylla[i].TeacherID;
                    dr[5] = sylla[i].AC;
                    dr[6] = sylla[i].AS;

对行的数据进行赋值,填充数据
                 }

 

........................................................................................................................................................

就这样我们将在数组中的数据赋值到了相应的表上