DataTable的一些基础用法

来源：互联网发布：vmware for ubuntu 编辑：程序博客网时间：2024/05/01 09:46

using System;using System.Collections.Generic;using System.Data;using System.Data.SqlClient;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;public partial class Index : System.Web.UI.Page{    protected void Page_Load(object sender, EventArgs e)    {        if (!IsPostBack)        {            DataTable dt = new DataTable();            //表名            dt.TableName = "userInfo";            //列            dt.Columns.Add("userName", typeof(string));            dt.Columns.Add("userSex", typeof(string));            dt.Columns.Add("userPhone", typeof(string));            dt.Columns.Add("userEmail", typeof(string));            dt.Columns.Add("userSchool", typeof(string));            dt.Columns.Add("userClass", typeof(string));            //行            DataRow dr = dt.NewRow();            dt.Rows.Add(dr);            dr["userName"] = "wang";            dr["userSex"] = "女";            dr["userPhone"] = "15236547852";            dr["userEmail"] = "187552369@qq.com";            dr["userSchool"] = "一中";            dr["userClass"] = "高一(1)班";            //复制DataTable            DataTable dtNew = dt.Copy();            string strSql = "select * from UserInfo";            DataTable dtSql = SqlHelper.ExecuteDataset(CommandType.Text, strSql).Tables[0];            foreach (DataRow drNew in dtSql.Rows)            {                dtNew.ImportRow(drNew);//赋值            }            //去除重复数据            DataView dv = new DataView(dtNew);            dtNew = dv.ToTable(true);        }    }}

1、创建一个新的Datatable

2、增加列名

3、添加一条行数据

4、复制DataTable(包括数据)

5、被导入的DataTable

6、导入后的DataTable

0 0