当前位置: 首页 > 图文教程 > 网络编程 > ASP.NET > DataSet 添加数据集、行、列、主键和外键等操作示例

ASP.NET
Asp.net 时间操作基类(支持短日期,长日期,时间差)
asp.net 获取机器硬件信息(cpu频率、磁盘可用空间、内存容量等)
asp.net 数据库备份还原(sqlserver+access)
Asp.Net 数据操作类(附通用数据基类)
Asp.net 弹出对话框基类(输出alet警告框)
Asp.net 文件上传类(取得文件后缀名,保存文件,加入文字水印)
Asp.net Socket客户端(远程发送和接收数据)
Asp.net 字符串操作基类(安全,替换,分解等)
Asp.Net数据输出到EXCEL表格中
asp.net Gridview里添加汇总行
asp.net UpdatePanel的简单用法
asp.net ajaxControlToolkit FilteredTextBoxExtender的简单用法
this connector is disabled错误的解决方法
sql事务应用积累
asp.net Page.Controls对象(找到所有服务器控件)
在asp.NET中字符串替换的五种方法
ASP.NET缓存方法分析和实践示例代码
asp.net 在DNN模块开发中遇到的resx怪问题
ASP.NET State service状态服务的问题解决方法
asp.net 结合mysql存储过程进行分页代码

ASP.NET 中的 DataSet 添加数据集、行、列、主键和外键等操作示例


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-09-13   浏览: 105 ::
收藏到网摘: n/a

前台代码: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();