DataTable应用

Dear 丶 2021-12-24 15:03 256阅读 0赞

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][] code   
![None.gif][]using System;  
![None.gif][]using System.Collections;  
![None.gif][]using System.Configuration;  
![None.gif][]using System.Data;  
![None.gif][]using System.Linq;  
![None.gif][]using System.Web;  
![None.gif][]using System.Web.Security;  
![None.gif][]using System.Web.UI;  
![None.gif][]using System.Web.UI.HtmlControls;  
![None.gif][]using System.Web.UI.WebControls;  
![None.gif][]using System.Web.UI.WebControls.WebParts;  
![None.gif][]using System.Xml.Linq;  
![None.gif][]  
![None.gif][]publicpartialclass DataTable应用 : System.Web.UI.Page  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][]![dot.gif][]\{  
![InBlock.gif][]protectedvoid Page\_Load(object sender, EventArgs e)  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][]  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]  
![InBlock.gif][]protectedvoid btnCreate\_Click(object sender, System.EventArgs e)  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][] DataSet dsUntyped =new DataSet("myDS");//创建数据集  
![InBlock.gif][] DataTable dtMaster =new DataTable("Master");//创建数据表  
![InBlock.gif][] DataTable dtChild =new DataTable("Child");  
![InBlock.gif][] dsUntyped.Tables.Add(dtMaster);//把数据表添加到数据集中  
![InBlock.gif][] dsUntyped.Tables.Add(dtChild);  
![InBlock.gif][] Session\["ds"\] = dsUntyped;  
![InBlock.gif][]  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]  
![InBlock.gif][]protectedvoid btnAddColumn\_Click(object sender, System.EventArgs e)  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][] DataSet dsUntyped = (DataSet)Session\["ds"\];  
![InBlock.gif][] dsUntyped.Tables\["Master"\].Columns.Add("MasterID", typeof(int));  
![InBlock.gif][] dsUntyped.Tables\["Master"\].Columns.Add("MasterValue", typeof(string));  
![InBlock.gif][] dsUntyped.Tables\["Child"\].Columns.Add("MasterLink", typeof(int));  
![InBlock.gif][] dsUntyped.Tables\["Child"\].Columns.Add("ChildID", typeof(int));  
![InBlock.gif][] dsUntyped.Tables\["Child"\].Columns.Add("ChildValue", typeof(string));  
![InBlock.gif][]//修改表头  
![InBlock.gif][] dsUntyped.Tables\["Master"\].Columns\["MasterID"\].Caption ="主ID";  
![InBlock.gif][] dsUntyped.Tables\["Master"\].Columns\["MasterValue"\].Caption ="值";  
![InBlock.gif][] Session\["ds"\] = dsUntyped;  
![InBlock.gif][] Bind();  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]  
![InBlock.gif][]protectedvoid btnAddRow\_Click(object sender, System.EventArgs e)  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][]try  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][] DataSet dsUntyped = (DataSet)Session\["ds"\];  
![InBlock.gif][]//为Master表添加两行  
![InBlock.gif][] DataRow dr = dsUntyped.Tables\["Master"\].NewRow();  
![InBlock.gif][] dr\["MasterID"\] =1;  
![InBlock.gif][] dr\["MasterValue"\] ="One";  
![InBlock.gif][] dsUntyped.Tables\["Master"\].Rows.Add(dr);  
![InBlock.gif][] dr = dsUntyped.Tables\["Master"\].NewRow();  
![InBlock.gif][] dr\["MasterID"\] =2;  
![InBlock.gif][] dr\["MasterValue"\] ="Two";  
![InBlock.gif][] dsUntyped.Tables\["Master"\].Rows.Add(dr);  
![InBlock.gif][]//为child表添加1行  
![InBlock.gif][] dr = dsUntyped.Tables\["Child"\].NewRow();  
![InBlock.gif][] dr\["MasterLink"\] =1;  
![InBlock.gif][] dr\["ChildID"\] =1;  
![InBlock.gif][] dr\["ChildValue"\] ="ChildOne";  
![InBlock.gif][] dsUntyped.Tables\["Child"\].Rows.Add(dr);  
![InBlock.gif][] Session\["ds"\] = dsUntyped;  
![InBlock.gif][] Bind();  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]catch (Exception ee)  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][] Response.Write(ee.Message);  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]//添加唯一键  
![InBlock.gif][]protectedvoid Button1\_Click(object sender, System.EventArgs e)  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][] DataSet dsUntyped = (DataSet)Session\["ds"\];  
![InBlock.gif][]//表示对一组列的限制,列中所有值必须是唯一的  
![InBlock.gif][] System.Data.UniqueConstraint uc =new UniqueConstraint("unqi", dsUntyped.Tables\["Master"\].Columns\["MasterID"\]);  
![InBlock.gif][] dsUntyped.Tables\["Master"\].Constraints.Add(uc);  
![InBlock.gif][] Session\["ds"\] = dsUntyped;  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]privatevoid Bind()  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][] DataSet dsUntyped = (DataSet)Session\["ds"\];  
![InBlock.gif][] dgMaster.DataSource = dsUntyped.Tables\["Master"\].DefaultView;  
![InBlock.gif][] dgChild.DataSource = dsUntyped.Tables\["Child"\].DefaultView;  
![InBlock.gif][]this.DataBind();  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]  
![InBlock.gif][]protectedvoid btnAddForeign\_Click(object sender, System.EventArgs e)  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][]//添加外键  
![InBlock.gif][] DataSet dsUntyped = (DataSet)Session\["ds"\];  
![InBlock.gif][] System.Data.ForeignKeyConstraint fc =new ForeignKeyConstraint("fc", dsUntyped.Tables\["Master"\].Columns\["MasterID"\], dsUntyped.Tables\["Child"\].Columns\["MasterLink"\]);  
![InBlock.gif][] dsUntyped.Tables\["Child"\].Constraints.Add(fc);  
![InBlock.gif][] Session\["ds"\] = dsUntyped;  
![InBlock.gif][]  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]  
![InBlock.gif][]protectedvoid btnUpdateMID\_Click(object sender, System.EventArgs e)  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][] DataSet dsUntyped = (DataSet)Session\["ds"\];  
![InBlock.gif][] dsUntyped.Tables\["Master"\].Rows\[0\]\["MasterID"\] =4;  
![InBlock.gif][] Bind();  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]  
![InBlock.gif][]protectedvoid Button2\_Click(object sender, System.EventArgs e)  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][] DataSet dsUntyped = (DataSet)Session\["ds"\];  
![InBlock.gif][]int nIndexTb =int.Parse(ddlTable.SelectedItem.Value);  
![InBlock.gif][]int nIndexRow =int.Parse(tbRow.Text);  
![InBlock.gif][]int nIndexCol =int.Parse(tbCol.Text);  
![InBlock.gif][]object obj = dsUntyped.Tables\[nIndexTb\].Rows\[nIndexRow\]\[nIndexCol\];  
![InBlock.gif][] tbResult.Text = obj.ToString();  
![InBlock.gif][]  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]  
![InBlock.gif][]protectedvoid btnUpdateDs\_Click(object sender, System.EventArgs e)  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][] DataSet dsUntyped = (DataSet)Session\["ds"\];  
![InBlock.gif][]int nIndexTb =int.Parse(ddlTable.SelectedItem.Value);  
![InBlock.gif][]int nIndexRow =int.Parse(tbRow.Text);  
![InBlock.gif][]int nIndexCol =int.Parse(tbCol.Text);  
![InBlock.gif][] dsUntyped.Tables\[nIndexTb\].Rows\[nIndexRow\]\[nIndexCol\] = tbResult.Text;  
![InBlock.gif][] Session\["ds"\] = dsUntyped;  
![InBlock.gif][] Bind();  
![ExpandedSubBlockEnd.gif][] \}  
![ExpandedBlockEnd.gif][]\}  
![None.gif][]

转载于:https://www.cnblogs.com/hubcarl/archive/2009/03/27/1423536.html

[ContractedBlock.gif]: https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif
[ExpandedBlockStart.gif]: /images/20211223/4319f588bedb422dba65a80d2bc4a8cf.png
[None.gif]: /images/20211223/8c3c5da264324f2ebd80706e99927808.png
[dot.gif]: /images/20211223/ae1467184b084bf6b96060167962623e.png
[InBlock.gif]: /images/20211223/f45f58b9f50e4441b37d5f4364148d7c.png
[ExpandedSubBlockStart.gif]: https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif
[ContractedSubBlock.gif]: https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif
[ExpandedSubBlockEnd.gif]: /images/20211223/c454472687ab44f78324fff860253803.png
[ExpandedBlockEnd.gif]: /images/20211223/73bbba9e417f4d45887c132bacf380d0.png