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

简介:
前台代码:html
<% @ Page language="c#" Codebehind="CodeUse.aspx.cs" AutoEventWireup="false" Inherits="DsAndXML.CodeUse" %>
<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
< HTML >
< HEAD >
< title >CodeUse </ title >
< meta content ="Microsoft Visual Studio 7.0" name ="GENERATOR" >
< meta content ="C#" name ="CODE_LANGUAGE" >
< meta content ="JavaScript" name ="vs_defaultClientScript" >
< meta content ="http://schemas.microsoft.com/intellisense/ie5" name ="vs_targetSchema" >
</ HEAD >
< body MS_POSITIONING ="GridLayout" >
< form id ="CodeUse" method ="post" runat ="server" >
< FONT face ="宋体" >
< asp:button id ="btnCreate" style ="Z-INDEX: 100; LEFT: 31px; POSITION: absolute; TOP: 43px" runat ="server" Height ="36" Width ="130" Text ="创建数据集和数据表" ></ asp:button >
< asp:Button id ="btnUpdateDs" style ="Z-INDEX: 117; LEFT: 35px; POSITION: absolute; TOP: 439px" runat ="server" Height ="36px" Width ="131px" Text ="赋值" ></ asp:Button >
< asp:Label id ="Label3" style ="Z-INDEX: 112; LEFT: 352px; POSITION: absolute; TOP: 395px" runat ="server" >列号: </ asp:Label >
< asp:Label id ="Label2" style ="Z-INDEX: 111; LEFT: 209px; POSITION: absolute; TOP: 395px" runat ="server" >行号: </ asp:Label >
< asp:Button id ="btnUpdateMID" style ="Z-INDEX: 107; LEFT: 37px; POSITION: absolute; TOP: 330px" runat ="server" Height ="36" Width ="131" Text ="修改MasterID" ></ asp:Button >
< asp:Button id ="btnAddForeign" style ="Z-INDEX: 106; LEFT: 35px; POSITION: absolute; TOP: 278px" runat ="server" Height ="36" Width ="131" Text ="添加外键" ></ asp:Button >
< 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 >
< asp:TextBox id ="tbRow" style ="Z-INDEX: 108; LEFT: 275px; POSITION: absolute; TOP: 395px" runat ="server" Width ="54px" ></ asp:TextBox >
< asp:TextBox id ="tbCol" style ="Z-INDEX: 109; LEFT: 422px; POSITION: absolute; TOP: 395px" runat ="server" Width ="64px" ></ asp:TextBox >
< asp:Label id ="Label1" style ="Z-INDEX: 110; LEFT: 520px; POSITION: absolute; TOP: 399px" runat ="server" >值: </ asp:Label >
< asp:TextBox id ="tbResult" style ="Z-INDEX: 113; LEFT: 585px; POSITION: absolute; TOP: 394px" runat ="server" Width ="145px" ></ asp:TextBox >
< asp:Label id ="Label4" style ="Z-INDEX: 114; LEFT: 209px; POSITION: absolute; TOP: 344px" runat ="server" >表: </ asp:Label >
< asp:DropDownList id ="ddlTable" style ="Z-INDEX: 115; LEFT: 277px; POSITION: absolute; TOP: 341px" runat ="server" >
< asp:ListItem Value ="0" >表一 </ asp:ListItem >
< asp:ListItem Value ="1" >表二 </ asp:ListItem >
</ asp:DropDownList >
< 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 >
</ body >
</ HTML >
后台代码:cs
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace DsAndXML
{
/// <summary>
/// CodeUse 的摘要说明。
/// </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)
{
// 在此处放置用户代码以初始化页面
}


Web Form Designer generated code

private void btnCreate_Click(object sender, System.EventArgs e)
{
DataSet dsUntyped = new DataSet("myDS");//创建数据集
DataTable dtMaster = new DataTable("Master");//创建数据表
DataTable dtChild = new DataTable("Child");
dsUntyped.Tables.Add(dtMaster);//把数据表添加到数据集中
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()方法获得的字符串再转成DataSet对象
DataSet ds = db.ExecSqlForDataSet( strSQL );
string strDS = ds.GetXml();

// 如何把strDS转换成DataSet对象??

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

String strDS = " "
System.IO.StringReader reader = new System.IO.StringReader(strDS);
ds.ReadXml(reader);
reader.Close();




本文转自高海东博客园博客,原文链接:http://www.cnblogs.com/ghd258/archive/2005/10/13/254216.html,如需转载请自行联系原作者
相关文章
|
关系型数据库 索引
DB2查询主键、索引、表约束
DB2查询主键、索引、表约束
818 0
|
2月前
|
存储 JSON BI
关于建表字段是否该使用not null这个问题你怎么看?
V哥分享了在数据库设计中使用 `NOT NULL` 的重要性及应用场景。关键字段如用户名和邮箱应设为 `NOT NULL` 以确保数据完整性;可选字段如中间名和个人资料图片允许 `NULL` 提供更多灵活性。`NULL` 还可用于表示未知状态,如未发货的订单。外键设计需根据业务逻辑决定是否使用 `NOT NULL`。此外,`NOT NULL` 可优化查询性能,但在扩展性和数据兼容性方面,允许 `NULL` 更具优势。结合业务需求和数据统计,合理使用 `NOT NULL` 可确保数据完整性和灵活性。
|
SQL
一条集多表查询、字段与字段拼接、合并每张表共同字段、新增列并赋值的SQL
一条集多表查询、字段与字段拼接、合并每张表共同字段、新增列并赋值的SQL
67 0
|
关系型数据库 MySQL Java
给数据表添加或者删除列|学习笔记
快速学习给数据表添加或者删除列
129 0
|
算法 前端开发
前端算法-Excel表的列名称
前端算法-Excel表的列名称
|
Linux
为表的所有字段插入数据
为表的所有字段插入数据
184 1
DataTable 修改列名 删除列 调整列顺序
DataTable 修改列名 删除列 调整列顺序
213 0
|
关系型数据库 MySQL
mysql用一个表中的字段批量更新另一个表中的字段
mysql用一个表中的字段批量更新另一个表中的字段
661 0