DataTable into DataSet

最新推荐文章于 2024-04-07 11:33:49 发布

xiaoliangaccp

最新推荐文章于 2024-04-07 11:33:49 发布

阅读量312

点赞数

分类专栏： C# 文章标签： dataset table insert class system website

本文链接：https://blog.csdn.net/xiaoliangaccp/article/details/5396195

版权

C# 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

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