protected void Button4_Click(object sender, EventArgs e)
{
string conString = "data source=127.0.0.1;initial catalog=codematic;user id=sa;password=";
string strSQL = "SELECT * FROM P_Product;SELECT * FROM P_Category";
SqlConnection myConnection = new SqlConnection(conString);
DataSet ds = new DataSet();
myConnection.Open();
SqlDataAdapter adapter = new SqlDataAdapter(strSQL, myConnection);
adapter.Fill(ds, "Product");
myConnection.Close();
【1】得到DataView
//DataView dv = ds.Tables[0].DefaultView;
或
//DataView dv = new DataView(ds.Tables["Product"], "ID > 52", "ID DESC", DataViewRowState.CurrentRows);
【2】得到DataView的行数据
//foreach (DataRowView rowview in dv)
//{
// for (int i = 0; i < dv.Table.Columns.Count; i++)
// {
// Response.Write(rowview[i] + "<br>");
// }
//}
【3】对结果集过滤排序
//DataView dv = ds.Tables[0].DefaultView;
//dv.RowFilter = "ID > 52";
//dv.Sort = "ID DESC";
//int c = dv.Count;
//if (c > 51)
//{
// for (int n = 50; n < c; n++)
// {
// dv.Delete(n);
// }
//}
//this.DataGrid1.DataSource = dv;
}