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"; }
和GridView的配合使用<form id="form1" runat="server"> <div> <% = Dv[0][0].ToString() %> \ <% = Dv[0]["Title"].ToString() %> \ <% = Dv[0].Row["Content"].ToString() %> <br /> </div> </form>
读取xml里的信息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());
<Root> <Catalog title="菜菜灰" id="2"/> <Catalog title="caicaihui" id="11"/> </Root>
0
相关文章