DataSet 添加數(shù)據(jù)集、行、列、主鍵和外鍵等操作示例

2019-11-18 16:47:53

字體：大中小

供稿：網(wǎng)友

namespace DsAndXML
{
    /**//// <summary>
    /// CodeUse 的摘要說(shuō)明。
    /// </summary>
    public class CodeUse : System.Web.UI.Page
    {
        PRotected System.Web.UI.WebControls.Button btnAddColumn;
        protected System.Web.UI.WebControls.Button btnAddRow;
        protected System.Web.UI.WebControls.DataGrid dgMaster;
        protected System.Web.UI.WebControls.DataGrid dgChild;
        protected System.Web.UI.WebControls.Button Button1;
        protected System.Web.UI.WebControls.Button btnAddForeign;
        protected System.Web.UI.WebControls.Button btnUpdateMID;
        protected System.Web.UI.WebControls.TextBox tbRow;
        protected System.Web.UI.WebControls.TextBox tbCol;
        protected System.Web.UI.WebControls.Label Label1;
        protected System.Web.UI.WebControls.Label Label2;
        protected System.Web.UI.WebControls.Label Label3;
        protected System.Web.UI.WebControls.TextBox tbResult;
        protected System.Web.UI.WebControls.Label Label4;
        protected System.Web.UI.WebControls.DropDownList ddlTable;
        protected System.Web.UI.WebControls.Button Button2;
        protected System.Web.UI.WebControls.Button btnUpdateDs;
        protected System.Web.UI.WebControls.Button btnCreate;

        private void Page_Load(object sender, System.EventArgs e)
        {
            // 在此處放置用戶代碼以初始化頁(yè)面
        }

        Web Form Designer generated code#region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN：該調(diào)用是 asp.net Web 窗體設(shè)計(jì)器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }

        /**//// <summary>
        /// 設(shè)計(jì)器支持所需的方法 - 不要使用代碼編輯器修改
        /// 此方法的內(nèi)容。
        /// </summary>
        private void InitializeComponent()
        {
            this.btnCreate.Click += new System.EventHandler(this.btnCreate_Click);
            this.btnAddRow.Click += new System.EventHandler(this.btnAddRow_Click);
            this.btnAddColumn.Click += new System.EventHandler(this.btnAddColumn_Click);
            this.Button1.Click += new System.EventHandler(this.Button1_Click);
            this.btnAddForeign.Click += new System.EventHandler(this.btnAddForeign_Click);
            this.btnUpdateMID.Click += new System.EventHandler(this.btnUpdateMID_Click);
            this.Button2.Click += new System.EventHandler(this.Button2_Click);
            this.btnUpdateDs.Click += new System.EventHandler(this.btnUpdateDs_Click);
            this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

        private void btnCreate_Click(object sender, System.EventArgs e)
        {
            DataSet dsUntyped = new DataSet("myDS");//創(chuàng)建數(shù)據(jù)集
            DataTable dtMaster = new DataTable("Master");//創(chuàng)建數(shù)據(jù)表
            DataTable dtChild = new DataTable("Child");
            dsUntyped.Tables.Add(dtMaster);//把數(shù)據(jù)表添加到數(shù)據(jù)集中
            dsUntyped.Tables.Add(dtChild);
            Session["ds"] = dsUntyped;

        }

        private void btnAddColumn_Click(object sender, System.EventArgs e)
        {
            DataSet dsUntyped = (DataSet)Session["ds"];
            dsUntyped.Tables["Master"].Columns.Add("MasterID",typeof(int));
            dsUntyped.Tables["Master"].Columns.Add("MasterValue",typeof(string));
            dsUntyped.Tables["Child"].Columns.Add("MasterLink",typeof(int));
            dsUntyped.Tables["Child"].Columns.Add("ChildID",typeof(int));
            dsUntyped.Tables["Child"].Columns .Add("ChildValue",typeof(string));
            //修改表頭
            dsUntyped.Tables["Master"].Columns["MasterID"].Caption = "主ID";
            dsUntyped.Tables["Master"].Columns["MasterValue"].Caption = "值";
            Session["ds"] = dsUntyped;
            Bind();
        }

        private void btnAddRow_Click(object sender, System.EventArgs e)
        {
            try
            {
                DataSet dsUntyped = (DataSet)Session["ds"];
                //為Master表添加兩行
                DataRow dr = dsUntyped.Tables["Master"].NewRow();
                dr["MasterID"] = 1;
                dr["MasterValue"] = "One";
                dsUntyped.Tables["Master"].Rows.Add(dr);
                dr = dsUntyped.Tables["Master"].NewRow();
                dr["MasterID"] = 2;
                dr["MasterValue"] = "Two";
                dsUntyped.Tables["Master"].Rows.Add(dr);
                //為child表添加1行
                dr = dsUntyped.Tables["Child"].NewRow();
                dr["MasterLink"] = 1;
                dr["ChildID"] = 1;
                dr["ChildValue"] = "ChildOne";
                dsUntyped.Tables["Child"].Rows.Add(dr);
                Session["ds"] = dsUntyped;
                Bind();
            }
            catch(Exception ee)
            {
                Response.Write(ee.Message);
            }

        }
        //添加唯一鍵
        private void Button1_Click(object sender, System.EventArgs e)
        {
            DataSet dsUntyped = (DataSet)Session["ds"];
            System.Data.UniqueConstraint uc = new UniqueConstraint("unqi",dsUntyped.Tables["Master"].Columns["MasterID"]);
            dsUntyped.Tables["Master"].Constraints.Add(uc);
            Session["ds"] = dsUntyped;
        }
        private void Bind()
        {
            DataSet dsUntyped = (DataSet)Session["ds"];
            dgMaster.DataSource = dsUntyped.Tables["Master"].DefaultView;
            dgChild.DataSource = dsUntyped.Tables["Child"].DefaultView;
            this.DataBind();
        }

        private void btnAddForeign_Click(object sender, System.EventArgs e)
        {
            DataSet dsUntyped = (DataSet)Session["ds"];
            System.Data.ForeignKeyConstraint fc = new ForeignKeyConstraint("fc",dsUntyped.Tables["Master"].Columns["MasterID"],dsUntyped.Tables["Child"].Columns["MasterLink"]);
            dsUntyped.Tables["Child"].Constraints.Add(fc);
            Session["ds"] = dsUntyped;

}

        private void btnUpdateMID_Click(object sender, System.EventArgs e)
        {
            DataSet dsUntyped = (DataSet)Session["ds"];
            dsUntyped.Tables["Master"].Rows[0]["MasterID"] = 4;
            Bind();
        }

        private void Button2_Click(object sender, System.EventArgs e)
        {
            DataSet dsUntyped = (DataSet)Session["ds"];
            int nIndexTb = int.Parse(ddlTable.SelectedItem.Value);
            int nIndexRow = int.Parse(tbRow.Text);
            int nIndexCol = int.Parse(tbCol.Text);
            object obj = dsUntyped.Tables[nIndexTb].Rows[nIndexRow][nIndexCol];
            tbResult.Text = obj.ToString();

        }

        private void btnUpdateDs_Click(object sender, System.EventArgs e)
        {
            DataSet dsUntyped = (DataSet)Session["ds"];
            int nIndexTb = int.Parse(ddlTable.SelectedItem.Value);
            int nIndexRow = int.Parse(tbRow.Text);
            int nIndexCol = int.Parse(tbCol.Text);
            dsUntyped.Tables[nIndexTb].Rows[nIndexRow][nIndexCol] = tbResult.Text;
            Session["ds"] = dsUntyped;
            Bind();
        }
    }
}如何把利用DataSet的GetXml()方法獲得的字符串再轉(zhuǎn)成DataSet對(duì)象
DataSet ds = db.ExecSqlForDataSet( strSQL );
string strDS = ds.GetXml();

//如何把strDS轉(zhuǎn)換成DataSet對(duì)象??

--------------------------------------------------------------------------------

String strDS = ""
System.IO.StringReader reader = new System.IO.StringReader(strDS);
ds.ReadXml(reader);
reader.Close();
http://www.survivalescaperooms.com/skylaugh/archive/2006/12/18/595646.html

上一篇：XML 增、刪、改和查示例

下一篇：讀寫xml所有節(jié)點(diǎn)個(gè)人小結(jié)和讀取xml節(jié)點(diǎn)的數(shù)據(jù)總結(jié)