62,046
社区成员
发帖
与我相关
我的任务
分享
DataTable ds=new DataTable();
ds.Columns.Add(new DataColumn("ID",typeof(int)));
ds.Columns.Add(new DataColumn("name",typeof(string)));
//ds.Columns["ID"].Unique=true;
DataRow dr;
dr=ds.NewRow();
dr[0]=1;
dr[1]="a";
ds.Rows.Add(dr);
dr=ds.NewRow();
dr[0]=1;
dr[1]="a";
ds.Rows.Add(dr);
dr=ds.NewRow();
dr[0]=4;
dr[1]="b";
ds.Rows.Add(dr);
dr=ds.NewRow();
dr[0]=1;
dr[1]="a";
ds.Rows.Add(dr);
dr=ds.NewRow();
dr[0]=3;
dr[1]="d";
ds.Rows.Add(dr);
dr=ds.NewRow();
dr[0]=4;
dr[1]="b";
ds.Rows.Add(dr);
DataTable ds2=new DataTable();
ds2.Columns.Add(new DataColumn("ID",typeof(int)));
ds2.Columns.Add(new DataColumn("name",typeof(string)));
ds2.Columns["ID"].Unique=true;
for (int i=0;i<ds.Rows.Count;i++)
{
try
{
dr=ds2.NewRow();
dr[0]=Convert.ToInt32(ds.Rows[i]["ID"].ToString());
dr[1]=ds.Rows[i]["name"].ToString();
ds2.Rows.Add(dr);
}
catch{}
}
Response.Write(ds2.Rows.Count);
public DataTable GetData(DataTable ds)
{
DataTable ds2=ds.Copy;
System.Data.DataColumnCollection ColumnCollection = ds2.Columns;
System.Data.DataColumn[] ColumnPK = {ColumnCollection["ID"] ,ColumnCollection["name"]};//这里设置要剔除重复的列,也可以写在参数里面
ds2.PrimaryKey=ColumnPK;
for (int i=0;i<ds.Rows.Count;i++)
{
try
{
dr=ds2.NewRow();
dr[0]=Convert.ToInt32(ds.Rows[i]["ID"].ToString());
dr[1]=ds.Rows[i]["name"].ToString();
ds2.Rows.Add(dr);
}
catch{}
}
return ds2;
}
DataTable ds=new DataTable();
ds.Columns.Add(new DataColumn("ID",typeof(int)));
ds.Columns.Add(new DataColumn("name",typeof(string)));
//ds.Columns["ID"].Unique=true;
DataRow dr;
dr=ds.NewRow();
dr[0]=1;
dr[1]="a";
ds.Rows.Add(dr);
dr=ds.NewRow();
dr[0]=1;
dr[1]="a";
ds.Rows.Add(dr);
dr=ds.NewRow();
dr[0]=4;
dr[1]="b";
ds.Rows.Add(dr);
dr=ds.NewRow();
dr[0]=1;
dr[1]="a";
ds.Rows.Add(dr);
dr=ds.NewRow();
dr[0]=3;
dr[1]="d";
ds.Rows.Add(dr);
dr=ds.NewRow();
dr[0]=4;
dr[1]="b";
ds.Rows.Add(dr);
DataTable ds2=new DataTable();
DataColumn mycol;
mycol=new DataColumn("ID",typeof(int));
ds2.Columns.Add(mycol);
mycol=new DataColumn("name",typeof(string));
ds2.Columns.Add(mycol);
System.Data.DataColumnCollection ColumnCollection = ds2.Columns;
System.Data.DataColumn[] ColumnPK = {ColumnCollection["ID"] ,ColumnCollection["name"]};
ds2.PrimaryKey=ColumnPK;
for (int i=0;i<ds.Rows.Count;i++)
{
try
{
dr=ds2.NewRow();
dr[0]=Convert.ToInt32(ds.Rows[i]["ID"].ToString());
dr[1]=ds.Rows[i]["name"].ToString();
ds2.Rows.Add(dr);
}
catch{}
}
Response.Write(ds2.Rows.Count);