DataTable into DataSet

来源:互联网 发布:2016年四川省经济数据 编辑:程序博客网 时间:2024/05/09 00:44

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Web.UI.WebControls; namespace WebSiteSQL { public class WebSiteSQLUI { public static void getGridView(System.Web.UI.Page page) { DataSet ds = new DataSet("orderTable"); DataTable dt1 = new DataTable("tbl1"); // table into dstaset ds.Tables.Add(dt1); //Create table head with one row and two columns DataColumn idColumn = new DataColumn("id", Type.GetType("System.Int32")); DataColumn ItemColumn = new DataColumn("Item", Type.GetType("System.String")); //one row and two columns insert into table dt1.Columns.Add(idColumn); dt1.Columns.Add(ItemColumn); //create datatable's row DataRow row; for (int i = 0; i < 10; i++) { row = dt1.NewRow(); row["id"] = i; row["Item"] = "Item" + i.ToString(); dt1.Rows.Add(row); } GridView gv = (GridView)page.FindControl("GridView1"); gv.DataSource = ds; gv.DataBind(); } } } using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Web.UI.WebControls; namespace WebSiteSQL { public class WebSiteSQLUI { public static void getGridView(System.Web.UI.Page page) { DataSet ds = new DataSet("orderTable"); DataTable dt1 = new DataTable("tbl1"); // table into dstaset ds.Tables.Add(dt1); //Create table head with one row and two columns DataColumn idColumn = new DataColumn("id", Type.GetType("System.Int32")); DataColumn ItemColumn = new DataColumn("Item", Type.GetType("System.String")); //one row and two columns insert into table dt1.Columns.Add(idColumn); dt1.Columns.Add(ItemColumn); //create datatable's row DataRow row; for (int i = 0; i < 10; i++) { row = dt1.NewRow(); row["id"] = i; row["Item"] = "Item" + i.ToString(); dt1.Rows.Add(row); } GridView gv = (GridView)page.FindControl("GridView1"); gv.DataSource = ds; gv.DataBind(); } } } view plaincopy to clipboardprint? namespace WebSite { public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { WebSiteSQL.WebSiteSQLUI.getGridView(Page); } } } 本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/guoyz_1/archive/2009/11/01/4755239.aspx

原创粉丝点击