当前位置：首页 > 资讯 > 技术文档

DataSet 添加数据集、行、列、主键和外键等操作示例

时间：2020-02-26 02:17 编辑：来源：阅读：
扫一扫，手机访问

摘要：DataSet 添加数据集、行、列、主键和外键等操作示例

前台代码：html

[img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif[/img] <%@ Page language="c#" Codebehind="CodeUse.aspx.cs" AutoEventWireup="false" Inherits="DsAndXML.CodeUse" %> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <HTML> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <HEAD> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <title>CodeUse</title> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <meta content="Microsoft Visual Studio 7.0" name="GENERATOR"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <meta content="C#" name="CODE_LANGUAGE"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <meta content="JavaScript" name="vs_defaultClientScript"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] </HEAD> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <body MS_POSITIONING="GridLayout"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <form id="CodeUse" method="post" runat="server"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <FONT face="宋体"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:button id="btnCreate" style="Z-INDEX: 100; LEFT: 31px; POSITION: absolute; TOP: 43px" runat="server" Height="36" Width="130" Text="创建数据集和数据表"></asp:button> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:Button id="btnUpdateDs" style="Z-INDEX: 117; LEFT: 35px; POSITION: absolute; TOP: 439px" runat="server" Height="36px" Width="131px" Text="赋值"></asp:Button> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:Label id="Label3" style="Z-INDEX: 112; LEFT: 352px; POSITION: absolute; TOP: 395px" runat="server">列号:</asp:Label> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:Label id="Label2" style="Z-INDEX: 111; LEFT: 209px; POSITION: absolute; TOP: 395px" runat="server">行号：</asp:Label> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:Button id="btnUpdateMID" style="Z-INDEX: 107; LEFT: 37px; POSITION: absolute; TOP: 330px" runat="server" Height="36" Width="131" Text="修改MasterID"></asp:Button> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:Button id="btnAddForeign" style="Z-INDEX: 106; LEFT: 35px; POSITION: absolute; TOP: 278px" runat="server" Height="36" Width="131" Text="添加外键"></asp:Button> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:Button id="Button1" style="Z-INDEX: 105; LEFT: 31px; POSITION: absolute; TOP: 217px" runat="server" Height="36px" Width="130px" Text="添加唯一键"></asp:Button><asp:button id="btnAddRow" style="Z-INDEX: 102; LEFT: 31px; POSITION: absolute; TOP: 161px" runat="server" Height="36px" Width="130px" Text="添加行"></asp:button><asp:button id="btnAddColumn" style="Z-INDEX: 101; LEFT: 31px; POSITION: absolute; TOP: 102px" runat="server" Height="36px" Width="130px" Text="添加列"></asp:button><asp:datagrid id="dgMaster" style="Z-INDEX: 103; LEFT: 242px; POSITION: absolute; TOP: 40px" runat="server" Height="120px" Width="485px"></asp:datagrid><asp:datagrid id="dgChild" style="Z-INDEX: 104; LEFT: 240px; POSITION: absolute; TOP: 193px" runat="server" Height="111px" Width="479px"></asp:datagrid> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:TextBox id="tbRow" style="Z-INDEX: 108; LEFT: 275px; POSITION: absolute; TOP: 395px" runat="server" Width="54px"></asp:TextBox> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:TextBox id="tbCol" style="Z-INDEX: 109; LEFT: 422px; POSITION: absolute; TOP: 395px" runat="server" Width="64px"></asp:TextBox> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:Label id="Label1" style="Z-INDEX: 110; LEFT: 520px; POSITION: absolute; TOP: 399px" runat="server">值：</asp:Label> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:TextBox id="tbResult" style="Z-INDEX: 113; LEFT: 585px; POSITION: absolute; TOP: 394px" runat="server" Width="145px"></asp:TextBox> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:Label id="Label4" style="Z-INDEX: 114; LEFT: 209px; POSITION: absolute; TOP: 344px" runat="server">表：</asp:Label> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:DropDownList id="ddlTable" style="Z-INDEX: 115; LEFT: 277px; POSITION: absolute; TOP: 341px" runat="server"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:ListItem Value="0">表一</asp:ListItem> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:ListItem Value="1">表二</asp:ListItem> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] </asp:DropDownList> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <asp:Button id="Button2" style="Z-INDEX: 116; LEFT: 35px; POSITION: absolute; TOP: 389px" runat="server" Height="36px" Width="131px" Text="求值"></asp:Button></FONT></form> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] </body> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] </HTML> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]

后台代码：cs

[img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Collections; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.ComponentModel; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Data; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Drawing; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Web; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Web.SessionState; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Web.UI; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Web.UI.WebControls; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Web.UI.HtmlControls; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] namespace DsAndXML [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif[/img] { [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img] /// <summary> [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] /// CodeUse 的摘要说明。 [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif[/img] /// </summary> [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] public class CodeUse : System.Web.UI.Page [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img] { [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.Button btnAddColumn; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.Button btnAddRow; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.DataGrid dgMaster; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.DataGrid dgChild; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.Button Button1; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.Button btnAddForeign; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.Button btnUpdateMID; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.TextBox tbRow; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.TextBox tbCol; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.Label Label1; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.Label Label2; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.Label Label3; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.TextBox tbResult; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.Label Label4; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.DropDownList ddlTable; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.Button Button2; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.Button btnUpdateDs; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] protected System.Web.UI.WebControls.Button btnCreate; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] private void Page_Load(object sender, System.EventArgs e) [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img] { [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] // 在此处放置用户代码以初始化页面 [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif[/img] } [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] Web Form Designer generated code#region Web Form Designer generated code [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] override protected void OnInit(EventArgs e) [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img] { [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] // [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。 [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] // [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] InitializeComponent(); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] base.OnInit(e); [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif[/img] } [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img] /// <summary> [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] /// 设计器支持所需的方法 - 不要使用代码编辑器修改 [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] /// 此方法的内容。 [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif[/img] /// </summary> [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] private void InitializeComponent() [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img] { [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] this.btnCreate.Click += new System.EventHandler(this.btnCreate_Click); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] this.btnAddRow.Click += new System.EventHandler(this.btnAddRow_Click); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] this.btnAddColumn.Click += new System.EventHandler(this.btnAddColumn_Click); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] this.Button1.Click += new System.EventHandler(this.Button1_Click); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] this.btnAddForeign.Click += new System.EventHandler(this.btnAddForeign_Click); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] this.btnUpdateMID.Click += new System.EventHandler(this.btnUpdateMID_Click); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] this.Button2.Click += new System.EventHandler(this.Button2_Click); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] this.btnUpdateDs.Click += new System.EventHandler(this.btnUpdateDs_Click); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] this.Load += new System.EventHandler(this.Page_Load); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif[/img] } [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif[/img] #endregion [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] private void btnCreate_Click(object sender, System.EventArgs e) [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img] { [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] DataSet dsUntyped = new DataSet("myDS");//创建数据集 [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] DataTable dtMaster = new DataTable("Master");//创建数据表 [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] DataTable dtChild = new DataTable("Child"); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dsUntyped.Tables.Add(dtMaster);//把数据表添加到数据集中 [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dsUntyped.Tables.Add(dtChild); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] Session["ds"] = dsUntyped; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif[/img] } [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] private void btnAddColumn_Click(object sender, System.EventArgs e) [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img] { [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] DataSet dsUntyped = (DataSet)Session["ds"]; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dsUntyped.Tables["Master"].Columns.Add("MasterID",typeof(int)); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dsUntyped.Tables["Master"].Columns.Add("MasterValue",typeof(string)); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dsUntyped.Tables["Child"].Columns.Add("MasterLink",typeof(int)); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dsUntyped.Tables["Child"].Columns.Add("ChildID",typeof(int)); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dsUntyped.Tables["Child"].Columns .Add("ChildValue",typeof(string)); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] //修改表头 [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dsUntyped.Tables["Master"].Columns["MasterID"].Caption = "主ID"; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dsUntyped.Tables["Master"].Columns["MasterValue"].Caption = "值"; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] Session["ds"] = dsUntyped; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] Bind(); [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif[/img] } [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] private void btnAddRow_Click(object sender, System.EventArgs e) [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img] { [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] try [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img] { [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] DataSet dsUntyped = (DataSet)Session["ds"]; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] //为Master表添加两行 [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] DataRow dr = dsUntyped.Tables["Master"].NewRow(); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dr["MasterID"] = 1; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dr["MasterValue"] = "One"; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dsUntyped.Tables["Master"].Rows.Add(dr); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dr = dsUntyped.Tables["Master"].NewRow(); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dr["MasterID"] = 2; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dr["MasterValue"] = "Two"; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] dsUntyped.Tables["Master"].Rows.Add(dr); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] &nbs

全部评论(0)

上一篇：asp.net获取系统当前时间的方法详解
下一篇：Visual Studio 2013如何使XML文件转换成类

资讯排行榜
更多>>

联系客服

客服电话：
400-000-3129

微信版

扫一扫进微信版

返回顶部