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