private void dataSetUpdate()
{
DataSet ds1 = DAOFactory.getSalesDAOInstance().getSalesDetailDataSetTEST();
Response.Write("初始行数:" +ds1.Tables[0].Rows.Count.ToString() +"<br>");
Response.Write("列数:" + ds1.Tables[0].Columns.Count.ToString() +"<br/>");
DataRow dr1 = ds1.Tables[0].NewRow();
//SalesOrderID,SalesOrderDetailID,CarrierTrackingNumber,productID,OrderQty
dr1["SalesOrderID"] = 9999;
dr1["SalesOrderDetailID"] = 9999;
dr1["CarrierTrackingNumber"] = "Hello!!";
for (int i = 2; i < ds1.Tables[0].Columns.Count ; i++)
{
dr1[i] = 0;
}
ds1.Tables[0].Rows.Add(dr1);
//for(int i = 0; i< ds1.Tables[0].Rows.Count ; i++)
//{
// for(int j= 0; j<ds1.Tables[0].Columns.Count ; j++)
// {
// Response.Write(ds1.Tables[0].Rows[i][j].ToString() + "|");
// }
// Response.Write("<br/>");
//}
DataTable dt1= new DataTable();
DataView dv1 = ds1.Tables[0].DefaultView; //默认视图
//dv1.Sort = "id Asc,name Desc";//id升序,name字段降序
dv1.Sort = "SalesOrderID ASC,CarrierTrackingNumber ASC";
dt1 = dv1.ToTable();
ds1.Tables[0].DefaultView.ToTable();
for (int i = 0; i < dt1.Rows.Count; i++)
{
for (int j = 0; j < dt1.Columns.Count; j++)
{
Response.Write( dt1.Rows[i][j].ToString() + "|");
}
Response.Write("<br/>");
}
}