ADO.NET_第六篇_DataSet

基础

例一

    string connStr = "data source=ora9; uid=scott; pwd=tiger; unicode=true";
    string sqlStr = "select * from emp";
    OracleConnection conn = new OracleConnection(connStr);
    OracleDataAdapter da = new OracleDataAdapter(sqlStr, conn);
    DataSet ds = new DataSet();
da.Fill(ds);
    //da.Fill(ds,"emp");
    foreach (DataRow dr in ds.Tables[0].Rows)
    {
        Response.Write(dr["empno"].ToString() + ", " + dr["ename"].ToString() + ", " + dr["mgr"].ToString());
    }
    conn.Close();

说明

1) 用OracleDataAdapter填充DataSet，并且可以规定DataSet的名字。

例二

    string connStr = "data source=ora9; uid=scott; pwd=tiger; unicode=true";
    string sqlStrEMP = "SELECT * FROM EMP";
    string sqlStrDEPT = "SELECT * FROM DEPT";
    OracleConnection conn = new OracleConnection(connStr);
    OracleDataAdapter daEmpTbl = new OracleDataAdapter(sqlStrEMP,connStr);
    OracleDataAdapter daDeptTbl = new OracleDataAdapter(sqlStrDEPT, connStr);
    DataSet ds = new DataSet();
    daEmpTbl.Fill(ds, "EMP");
    daDeptTbl.Fill(ds, "DEPT");
    Response.Write("EMP表：");
    foreach (DataRow dr in ds.Tables["EMP"].Rows)
    {
        Response.Write(dr["EMPNO"].ToString() + ", " + dr["ENAME"].ToString() + ", " + dr["MGR"].ToString() + " ");
    }
    Response.Write("DEPT表：");
    foreach (DataRow dr in ds.Tables["DEPT"].Rows)
    {
        Response.Write(dr["DEPTNO"].ToString() + ", " + dr["DNAME"].ToString() + ", " + dr["LOC"].ToString() + " ");
    }
    conn.Close();

说明

1) 用OracleDataAdapter向DataSet填充两个数据集。

更新

    string connStr = "data source=ora9; uid=scott; pwd=tiger; unicode=true";
    string sqlStr = "SELECT * FROM EMP";
    OracleConnection conn = new OracleConnection(connStr);
    OracleDataAdapter da = new OracleDataAdapter(sqlStr,connStr);
    DataSet ds = new DataSet();
    da.Fill(ds, "EMP");
    GridView1.DataSource = ds;
    GridView1.DataKeyNames = new string[] { "EMPNO" };
    GridView1.DataBind();
    ds.Tables["EMP"].Rows[0].Delete();
    da.Update(ds, "EMP");
    ds.Tables["EMP"].AcceptChanges();

读取XML文件

本例演示如何用DataSet操作XML文件

    DataSet ds = new DataSet();
    ds.ReadXml(Server.MapPath("book.xml"));
    foreach (DataRow dr in ds.Tables[0].Rows)
    {
        Response.Write(dr[0].ToString() + ", " + dr[1].ToString());
    }

自定义XML文件如下

<?xml version="1.0" encoding="utf-8" standalone="yes" ?>
<PUBLICATION>
  <BOOK>
    <TITLE>C#数据库系统开发完全手册</TITLE>
    <PAGES>628</PAGES>
  </BOOK>
  <BOOK>
    <TITLE>ASP.NET程序开发范例宝典</TITLE>
    <PAGES>820</PAGES>
  </BOOK>
</PUBLICATION>

说明

1) XML文件的路径，既可以用绝对路径，也可以用 Server.MapPath 本地路径；

2) 当然也可以将DataSet中的内容写成XML文件的形式，这只需一个WriteXml方法即可。