.net 1.1中的解决方法(转)
1建立一个DataSetHelper类(DataSetHelper.cs)
2 建立一个Web窗体，在page_load中写下面的代码
DataSet ds;
DataSetHelper dsHelper;
ds = new DataSet();
dsHelper = new DataSetHelper(ref ds);
// Create source table
DataTable dt = new DataTable("Orders");
dt.Columns.Add("EmployeeID", Type.GetType("System.String"));
dt.Columns.Add("OrderID", Type.GetType("System.Int32"));
dt.Columns.Add("Amount", Type.GetType("System.Decimal"));
dt.Rows.Add(new object[] { "Sam", 5, 25.00 });
dt.Rows.Add(new object[] { "Tom", 7, 50.00 });
dt.Rows.Add(new object[] { "Sue", 9, 11.00 });
dt.Rows.Add(new Object[] { "Tom", 12, 7.00 });
dt.Rows.Add(new Object[] { "Sam", 14, 512.00 });
dt.Rows.Add(new Object[] { "Sue", 15, 17.00 });
dt.Rows.Add(new Object[] { "Sue", 22, 2.50 });
dt.Rows.Add(new object[] { "Tom", 24, 3.00 });
dt.Rows.Add(new object[] { "Tom", 33, 78.75 });
ds.Tables.Add(dt);
DataTable td=dsHelper.SelectDistinct("DistinctEmployees", ds.Tables["Orders"], "EmployeeID");
this.GridView1.DataSource = td;
this.GridView1.DataBind();
.net 2.0中的解决方法(原创)
public DataTable GetTopSearch()
{
DataSet dsKeyword = dal.GetKeyword();
DataSet dsTopSearch = new DataSet();
for (int i = 0; i < 4; i++)
{
string keyword = dsKeyword.Tables[0].Rows[i]["Name"].ToString();
string condition = dsKeyword.Tables[0].Rows[i]["SearchCondition"].ToString();
dsTopSearch.Merge(dal.GetTopSearch(keyword,condition));
}
return dsTopSearch.Tables[0].DefaultView.ToTable(true, "ID","Name","Author","Publisher","PublishDate","TypeName","Price","SalePrice","SavePrice","Rebate","ImagePath","ContentIntro");
}
先把DataTable转成DataView,再通过DataView.ToTable()转回DataTable,ToTable()方法中有一个重载可以轻松消除重复行.
注:该重载的第二个参数为要保存的字段名.
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。