冰天雪地裸体跪求强类型DataSet使用实例..

Question

哪位大虾有这些教程啊?(winform的 ) 麻烦发给我好吗? [email protected]

Answer 1

http://msdn.microsoft.com/zh-cn/library/system.data.dataset.aspx

Answer 2

http://www.360doc.com/content/10/0426/11/1304528_24935825.shtml

Answer 3

楼主是要DataSet使用吗,是的话我简单分享一点内容,不知有没帮助
例1. DataSet使用
 前台:
<asp:Button ID="Button1" runat="server" Text="创建数据集与数据表" OnClick="Button1_Click" /><br />
        <asp:Button ID="Button2" runat="server" Text="添加行" OnClick="Button2_Click" /><br />
        <asp:Button ID="Button3" runat="server" Text="添加列" OnClick="Button3_Click" /><br />
        <asp:Button ID="Button4" runat="server" Text="添加唯一键" OnClick="Button4_Click" /><br />
        <asp:Button ID="Button5" runat="server" Text="添加外键" OnClick="Button5_Click" /><br />
        <asp:Button ID="Button6" runat="server" Text="修改MasterID" OnClick="Button6_Click" /><br />
        <asp:Button ID="Button7" runat="server" Text="求值" OnClick="Button7_Click" /><br />
        <asp:Button ID="Button8" runat="server" Text="赋值" OnClick="Button8_Click" />&nbsp;<br />
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
        <br />
        <asp:GridView ID="GridView2" runat="server">
        </asp:GridView>
后台:
using System.Xml;
using System.Xml.Schema;
    protected void Button1_Click(object sender, 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;
    }
    protected void Button3_Click(object sender, 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();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        DataSet dsUntyped = (DataSet)Session["ds"];
        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);
        dr = dsUntyped.Tables["Child"].NewRow();
        dr["ChildID"] = 1;
        dr["ChildValue"] = "childone";
        dsUntyped.Tables["Child"].Rows.Add(dr);
        Session["ds"] = dsUntyped;
        Bind();
    }
    protected void Button4_Click(object sender, 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;
    }
    protected void Button5_Click(object sender, 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 Bind()
    {
        DataSet dsUntyped = (DataSet)Session["ds"];
        GridView1.DataSource = dsUntyped.Tables["Master"].DefaultView;
        GridView2.DataSource = dsUntyped.Tables["Child"].DefaultView;
        this.DataBind();
    }
    protected void Button6_Click(object sender, EventArgs e)
    {
        DataSet dsUntyped = (DataSet)Session["ds"];
        dsUntyped.Tables["Master"].Rows[0]["MasterID"] = 4;
        Bind();
    }
    protected void Button7_Click(object sender, EventArgs e)
    {
        DataSet dsUntyped = (DataSet)Session["ds"];
        object obj = dsUntyped.Tables[0].Rows[0][0];
        Response.Write(obj.ToString());
    }
    protected void Button8_Click(object sender, EventArgs e)
    {
        DataSet dsUntyped = (DataSet)Session["ds"];
        dsUntyped.Tables[0].Rows[0][0] = 1;
        Session["ds"] = dsUntyped;
        Bind();
    }
*添加外键的话,主键变了,引用该主键作为外键的表进行修改.
例2:编码生成XSD文件.
using System.Xml;
using System.Xml.Schema;
XmlSchema sch = new XmlSchema();
        XmlSchemaElement elem = new XmlSchemaElement();
        sch.Items.Add(elem);
        elem.Name = "Book";
        XmlSchemaComplexType cType = new XmlSchemaComplexType();
        elem.SchemaType = cType;
        XmlSchemaSequence seq = new XmlSchemaSequence();
        cType.Particle = seq;
        XmlSchemaElement eleTitle = new XmlSchemaElement();
        eleTitle.Name = "Title";
        eleTitle.SchemaTypeName = new XmlQualifiedName("string","http://www.w3.org/2001/XMLSchema");
        XmlSchemaElement elePub = new XmlSchemaElement();
        elePub.Name = "Publisher";
        elePub.SchemaTypeName = new XmlQualifiedName("string","http://www.w3.org/2001/XMLSchema");
        seq.Items.Add(eleTitle);
        seq.Items.Add(elePub);
        sch.Compile(new ValidationEventHandler(ValidationHandler));
        StreamWriter sw = new StreamWriter(Server.MapPath("out.xsd"));
     sch.Write(sw.BaseStream);
public void ValidataionHandler(object sender,ValidationEventArgs args)
    {
        Response.Write("架构验证失败");
        Response.Write(args.Message);
}
产生的out.xsd文件内容为
<?xml version="1.0"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="Book">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="Title" type="xs:string" />
        <xs:element name="Publisher" type="xs:string" />
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>
例3.
DataSet ds1;
        ds1 = new DataSet();
        ds1.Tables.Add("Customers");
        ds1.Tables[0].Columns.Add("custid",typeof(int));
        ds1.Tables[0].Columns.Add("custname",typeof(string));
        ds1.Tables.Add("Orders");
        ds1.Tables[1].Columns.Add("custid",typeof(int));
        ds1.Tables[1].Columns.Add("orderid", typeof(int));
        ds1.Relations.Add(ds1.Tables["Customers"].Columns["custid"],ds1.Tables["Orders"].Columns["custid"]);
        GridView1.DataSource = ds1.Tables[0].DefaultView;
        GridView1.DataBind();
        GridView2.DataSource = ds1.Tables[1].DefaultView;
        GridView2.DataBind();
2. 通过一个DataAdapter类,使用数据库无数据来推断出架构
 例4.
DataSet ds1;
        ds1 = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter("select * from customers,select * from orders","server=.;uid=sa;pwd=111;database=test");
        da.FillSchema(ds1,SchemaType.Source);
        ds1.Tables[0].TableName = "Customers";
        ds1.Tables[1].TableName = "Orders";
        ds1.Relations.Add(ds1.Tables["Customers"].Columns["custid"], ds1.Tables["Orders"].Columns["custid"]);
        GridView1.DataSource = ds1.Tables[0].DefaultView;
        GridView1.DataBind();
        GridView2.DataSource = ds1.Tables[1].DefaultView;
        GridView2.DataBind();
3. 使用XSD定义需要的DataSet架构,并用DataSet.ReadXmlSchema将架构定义载入DataSet
例5.
DataSet ds1;
        ds1 = new DataSet();
        ds1.ReadXmlSchema(Server.MapPath("customer.xsd"));
        GridView1.DataSource = ds1.Tables[0].DefaultView;
        GridView1.DataBind();
例6.
DataSet ds1;
        ds1 = new DataSet();
        ds1.InferXmlSchema(Server.MapPath("customer.xml",null));
        GridView1.DataSource = ds1.Tables[0].DefaultView;
        GridView1.DataBind();
例7.根据xml文件生成xsd文件.
string strFileName = FileUpload1.PostedFile.FileName;
        DataSet MyDS = new DataSet();
        MyDS.ReadXml(strFileName);
        foreach (DataTable myTable in MyDS.Tables)
        {
            Response.Write("Table:"+myTable.TableName+"<br/>");
            foreach (DataColumn myColumn in myTable.Columns)
            {
                Response.Write(myColumn.ColumnName + "<br>");
            }
        }
        Response.Write("Relations:");
        foreach (DataRelation myRelation in MyDS.Relations)
        {
            Response.Write(myRelation.RelationName);
        }
        MyDS.WriteXmlSchema(Server.MapPath("XMLOut.xsd"));

Answer 4

http://social.msdn.microsoft.com/Search/zh-CN?query=dataset&ac=8