在web上创建好了DataTable 要显示在页面上 怎么办

Question

在web上创建好了DataTable 要显示在页面上 怎么办

Answer 1

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.IO;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;public partial class _Default : System.Web.UI.Page
{
    private void MakeDataTableAndDisplay()
    {
        // Create new DataTable.
        DataTable table = new DataTable();        // Declare DataColumn and DataRow variables.
        DataColumn column;
        DataRow row;        // Create new DataColumn, set DataType, ColumnName
        // and add to DataTable.    
        column = new DataColumn();
        column.DataType = System.Type.GetType("System.String");
        column.ColumnName = "DEPT";
        column.AllowDBNull = false;
        table.Columns.Add(column);

Answer 2

 // Create second column.
        column = new DataColumn();
        column.DataType = Type.GetType("System.String");
        column.ColumnName = "LEADER";
        column.AllowDBNull = false;
        table.Columns.Add(column);        column = new DataColumn();
        column.DataType = Type.GetType("System.Int32");
        column.ColumnName = "LEADERLEVEL";
        column.AllowDBNull = false;
        table.Columns.Add(column);        column = new DataColumn();
        column.DataType = Type.GetType("System.String");
        column.ColumnName = "UPDEPT";
        column.AllowDBNull = false;
        table.Columns.Add(column);        column = new DataColumn();
        column.DataType = Type.GetType("System.String");
        column.ColumnName = "COSTCENTER";
        column.AllowDBNull = true;
        table.Columns.Add(column);        // Create new DataRow objects and add to DataTable.   
        row = table.NewRow();
        row["DEPT"] = "IS%T/EAS";
        row["LEADER"] = "Brian Tsai/CTDSP";
        row["LEADERLEVEL"] = 2;
        row["UPDEPT"] = "IS%T";
        row["COSTCENTER"] = "9001S200";
        table.Rows.Add(row);        row = table.NewRow();
        row["DEPT"] = "IS%T/EAS/AS1";
        row["LEADER"] = "Brian Tsai/CTDSP";
        row["LEADERLEVEL"] = 3;
        row["UPDEPT"] = "IS%T/EAS";
        row["COSTCENTER"] = "9001S210";
        table.Rows.Add(row);        row = table.NewRow();
        row["DEPT"] = "IS%T/EAS/AS2";
        row["LEADER"] = "Brian Tsai/CTDSP";
        row["LEADERLEVEL"] = 3;
        row["UPDEPT"] = "IS%T/EAS";
        row["COSTCENTER"] = "9001S220";
        table.Rows.Add(row);

Answer 3

在web上创建好了DataTable 要显示在页面上 怎么办？？？？老大，你要怎么办？往数据控件上绑啊GridView Repeater DataList  随便你用什么数据控件

Answer 4

row = table.NewRow();
        row["DEPT"] = "IS%T/EAS/AS3";
        row["LEADER"] = "Candice Chen/CTDSP";
        row["LEADERLEVEL"] = 3;
        row["UPDEPT"] = "IS%T/EAS";
        row["COSTCENTER"] = "9001S230";
        table.Rows.Add(row);        row = table.NewRow();
        row["DEPT"] = "IS%T/EAS/ESI";
        row["LEADER"] = "Frank Huang/CTDSP";
        row["LEADERLEVEL"] = 3;
        row["UPDEPT"] = "IS%T/EAS";
        row["COSTCENTER"] = "9001S240";
        table.Rows.Add(row);        row = table.NewRow();
        row["DEPT"] = "IS%T/ISD";
        row["LEADER"] = "Spike Lin/CTDSP";
        row["LEADERLEVEL"] = 2;
        row["UPDEPT"] = "IS%T";
        row["COSTCENTER"] = "9001S300";
        table.Rows.Add(row);        row = table.NewRow();
        row["DEPT"] = "IS%T/ISD/PDM";
        row["LEADER"] = "Angus Chen/CTDSP";
        row["LEADERLEVEL"] = 3;
        row["UPDEPT"] = "IS%T/ISD";
        row["COSTCENTER"] = null;
        table.Rows.Add(row);        row = table.NewRow();
        row["DEPT"] = "IS%T/ISD/SD1";
        row["LEADER"] = "Angus Chen/CTDSP";
        row["LEADERLEVEL"] = 3;
        row["UPDEPT"] = "IS%T/ISD";
        row["COSTCENTER"] = "9001S320";
        table.Rows.Add(row);        row = table.NewRow();
        row["DEPT"] = "IS%T/ISD/SD2";
        row["LEADER"] = "Spike Lin/CTDSP";
        row["LEADERLEVEL"] = 3;
        row["UPDEPT"] = "IS%T";
        row["COSTCENTER"] = "9001S330";
        table.Rows.Add(row);
    }
}

Answer 5

gridview.dataSource=DataTable ;
gridview.dataBind();

Answer 6

页面上放一个 GridView1
然后
GridView1.DataSource = table;
GridView1.DataBind();

Answer 7

拖一个gridview到页面
然后后台
gridview1.datasource=你的datetable
gridview1.databind();
自己注意大小写

Answer 8

把你 Page_Load 贴上来

Answer 9

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>未命名頁面</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal">
            <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
            <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
            <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
            <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
            <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
            <AlternatingRowStyle BackColor="#F7F7F7" />
        </asp:GridView>
    
    </div>
    </form>
</body>
</html>我的是小写的 我原来代码之上就加了你说的这两句 其他的还有问题吗 帮看下

Answer 10

执行绑定怎么弄 我就是在刚才的C#代码最后加了那两句代码 然后在page页面用在浏览器查看 来看 就是想页面出来就是这个表

Answer 11

好我帮你实验protected void Page_Load(object sender, EventArgs e)
    {
        // Create new DataTable.
        DataTable table = new DataTable();        // Declare DataColumn and DataRow variables.
        DataColumn column;
        DataRow row;   
        column = new DataColumn();
        column.DataType = System.Type.GetType("System.String");
        column.ColumnName = "DEPT";
        column.AllowDBNull = false;
        table.Columns.Add(column);
        column = new DataColumn();
        column.DataType = Type.GetType("System.String");
        column.ColumnName = "LEADER";
        column.AllowDBNull = false;
        table.Columns.Add(column);        column = new DataColumn();
        column.DataType = Type.GetType("System.Int32");
        column.ColumnName = "LEADERLEVEL";
        column.AllowDBNull = false;
        table.Columns.Add(column);        column = new DataColumn();
        column.DataType = Type.GetType("System.String");
        column.ColumnName = "UPDEPT";
        column.AllowDBNull = false;
        table.Columns.Add(column);        column = new DataColumn();
        column.DataType = Type.GetType("System.String");
        column.ColumnName = "COSTCENTER";
        column.AllowDBNull = true;
        table.Columns.Add(column);        // Create new DataRow objects and add to DataTable.   
        row = table.NewRow();
        row["DEPT"] = "IS%T/EAS";
        row["LEADER"] = "Brian Tsai/CTDSP";
        row["LEADERLEVEL"] = 2;
        row["UPDEPT"] = "IS%T";
        row["COSTCENTER"] = "9001S200";
        table.Rows.Add(row);
        this.GridView1.DataSource = table;
        this.GridView1.DataBind();
        
    }OK代码

Answer 12

......
页面的Page_Load 方法有没有？没有就把下边的代码复制一下
 protected void Page_Load(object sender, EventArgs e)
{
    MakeDataTableAndDisplay();
}table.Rows.Add(row);后边加
GridView1.DataSource = table;
GridView1.DataBind();这两句

Answer 13

这个是要写在aspx页面 还是aspx。cs页面的

Answer 14

viewstate["dt"]=dt;
<% for循环 %>

Answer 15

去MSDN上看看 数据库容器的绑定方法

Answer 16

宝贝儿，先看看书，学做几个例子吧，这样的基础真的让人很无语..这个是写在 CS中的 public partial class _Default : System.Web.UI.Page
{
//====》 这里加PageLoad
protected void Page_Load(object sender, EventArgs e)
{
MakeDataTableAndDisplay();
}
private void MakeDataTableAndDisplay()
{
// 你自己写的加Table 的方法 略//在最后一行 table.Rows.Add(row);后边加
GridView1.DataSource = table;
GridView1.DataBind();
}这个够清楚了么？

Answer 17

恩 弄出来了 现在做这个就是我在学的例子啊 哈哈 没人教我 我自己看MSDN写了之前那些了 谢谢了 请接分！