技术开发 频道

DataView 使用技巧


【IT168技术文档】

  读取某个记录的详细信息
public DataView Dv; protected void Page_Load(object sender, EventArgs e) { Dv = new Caicai.DBHelper().ExecuteDataSet("select * from News").Tables[0].DefaultView; Dv.RowFilter = "id=2"; }
  前台调用
<form id="form1" runat="server"> <div> <% = Dv[0][0].ToString() %> \ <% = Dv[0]["Title"].ToString() %> \ <% = Dv[0].Row["Content"].ToString() %> <br /> </div> </form>
  和GridView的配合使用
Caicai.DBHelper MyHelper = new Caicai.DBHelper(); DataSet Ds = MyHelper.ExecuteDataSet("select * from News"); DataView Dv1 = Ds.Tables[0].DefaultView; Dv1.RowFilter = "id=1"; this.GridView1.DataSource = Dv1; this.GridView1.DataBind(); DataView Dv2 = Ds.Tables[0].DefaultView; Dv2.RowFilter = "id=2"; this.GridView2.DataSource = Dv2; this.GridView2.DataBind();
  读取xml里的信息
DataSet Ds = new DataSet(); Ds.ReadXml(Server.MapPath(@"App_Data/XMLFile.xml")); DataView Dv = Ds.Tables[0].DefaultView; Dv.RowFilter = "id='11'"; Response.Write(Dv[0]["title"].ToString());
  xml文件
<Root> <Catalog title="菜菜灰" id="2"/> <Catalog title="caicaihui" id="11"/> </Root>
0
相关文章