【转载】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;


        }

  • 0
    点赞
  • 0
    评论
  • 0
    收藏
  • 一键三连
    一键三连
  • 扫一扫,分享海报

©️2021 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值