【转载】DateView类的使用

 

 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;

        }