data.cs

来自「asp.net的右键菜单示列代码。对大家有的帮助吧」· CS 代码 · 共 90 行

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Data 的摘要说明
/// </summary>
public class Data
{
    public Data()
    {
    	//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
        //
        // TODO: 在此处添加构造函数逻辑
        //
    }

    private DataTable CreateStructure()
    {
        DataTable dt = new DataTable();
        dt.Columns.Add(new DataColumn("CategoryID", typeof(int)));
        dt.Columns.Add(new DataColumn("CategoryName", typeof(string)));
        dt.Columns.Add(new DataColumn("Price", typeof(int)));
        return dt;
    }
    public DataSet CreateData()
    {
        DataSet ds = new DataSet();
        DataTable dt = this.CreateStructure();

        DataRow drNew = dt.NewRow();
        drNew = dt.NewRow();
        drNew["CategoryID"] = 1;
        drNew["CategoryName"] = "Apple";
        drNew["Price"] = 2;
        dt.Rows.Add(drNew);

        drNew = dt.NewRow();
        drNew["CategoryID"] = 2;
        drNew["CategoryName"] = "Banana";
        drNew["Price"] = 3;
        dt.Rows.Add(drNew);

        drNew = dt.NewRow();
        drNew["CategoryID"] = 3;
        drNew["CategoryName"] = "Orange";
        drNew["Price"] = 1;
        dt.Rows.Add(drNew);

        drNew = dt.NewRow();
        drNew["CategoryID"] = 4;
        drNew["CategoryName"] = "Radish";
        drNew["Price"] = 2;
        dt.Rows.Add(drNew);

        drNew = dt.NewRow();
        drNew["CategoryID"] = 5;
        drNew["CategoryName"] = "51aspx";
        drNew["Price"] = 3;
        dt.Rows.Add(drNew);

        drNew = dt.NewRow();
        drNew["CategoryID"] = 6;
        drNew["CategoryName"] = "Pencil";
        drNew["Price"] = 7;
        dt.Rows.Add(drNew);

        drNew = dt.NewRow();
        drNew["CategoryID"] = 7;
        drNew["CategoryName"] = "Ruler";
        drNew["Price"] = 3;
        dt.Rows.Add(drNew);

        drNew = dt.NewRow();
        drNew["CategoryID"] = 8;
        drNew["CategoryName"] = "Eraser";
        drNew["Price"] = 5;
        dt.Rows.Add(drNew);

        ds.Tables.Add(dt);
        return ds;
    }
}