现在对DataTable与GridView一点不了解。怎样把DataTable绑定GridView,大家给一个例子,thanks!

解决方案 »

  1.   

    现在我把我做的如下
    cs文件:
    using System;
    using System.Configuration;
    using System.Data;
    using System.Web;
    using System.Web.Security;
    using System.Web.UI;
    using System.Web.UI.HtmlControls;
    using System.Web.UI.WebControls;
    using System.Web.UI.WebControls.WebParts;public partial class _Default : System.Web.UI.Page 
    {
        protected void Page_Load(object sender, EventArgs e)
        {
          
           
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            string id = id_TextBox.Text;
            string code = code_TextBox.Text;
            string name = name_TextBox.Text;        DataTable dt = new DataTable();
            dt.Columns.Add("Id", typeof(System.String));
            dt.Columns.Add("Code", typeof(System.String));
            dt.Columns.Add("Name", typeof(System.String));
            dt.Rows.Add(id, code, name);
      
            }  
        }-------------------------------------------------------------------
    aspx文件:<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <title>Untitled Page</title>
    </head>
    <body>
        <form id="form1" runat="server">
        <div align="center">
            
            <asp:Label ID="id_Label" runat="server" Text="ID:"></asp:Label>
            <asp:TextBox ID="id_TextBox" runat="server"></asp:TextBox>
            <br />
            <br />
            <asp:Label ID="code_Label" runat="server" Text="Code:"></asp:Label>
            <asp:TextBox ID="code_TextBox" runat="server"></asp:TextBox>
            <br />
            <br />
            <asp:Label ID="name_Label" runat="server" Text="Name:"></asp:Label>
            <asp:TextBox ID="name_TextBox" runat="server"></asp:TextBox>
            <br />
            <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="确定" />
            <br />
            <br />
            <table style="width:100%;">
                <tr>
                    <td>
                        <asp:GridView ID="GridView1" runat="server" BackColor="White" 
                            BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4" 
                            GridLines="Horizontal" Width="450px">
                            <FooterStyle BackColor="White" ForeColor="#333333" />
                            <RowStyle BackColor="White" ForeColor="#333333" />
                            <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
                            <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
                            <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
                        </asp:GridView>
                    </td>
                 </tr>
                <tr>
                    <td>
                     &nbsp;</td>
                </tr>
                
            </table>
            <br />
            <br />
            
        </div>
        </form>
    </body>
    </html>
    ----------------------------------------------
    现在我想把datatable数据在gridview上显示,谢谢了!
      

  2.   

    this.GridView.DataSource = DataTable;
    this.GridView.DataBind();
      

  3.   

    gridview.datasource=datatable
    gridview.databind()
      

  4.   


     protected void Button1_Click(object sender, EventArgs e)
      {
      string id = id_TextBox.Text;
      string code = code_TextBox.Text;
      string name = name_TextBox.Text;  DataTable dt = new DataTable();
      dt.Columns.Add("Id", typeof(System.String));
      dt.Columns.Add("Code", typeof(System.String));
      dt.Columns.Add("Name", typeof(System.String));
      dt.Rows.Add(id, code, name);
       //...添加几行数据,若没有数据又没做特殊处理,GridView是不现实空表头的
       GridView1.DataSource = dt;
       GridView1.DataBind();
      }
      

  5.   

    DataTable dt = new DataTable();
    dt.Columns.Add("Id", typeof(System.String));
    dt.Columns.Add("name", typeof(System.String));
    dt.Rows.Add("1","");GridView1.DataSource = dt;
    GridView1.DataBind();
      

  6.   

    public void BindGridView()
      {
      DataTable dt = new DataTable();
      DataColumn dc = new DataColumn("ID", Type.GetType("System.Int32"));
      dt.Columns.Add(dc);
      DataColumn dc1 = new DataColumn("Name", Type.GetType("System.String"));
      dt.Columns.Add(dc1);  DataRow dr = dt.NewRow();
      dr["ID"] = 1;
      dr["Name"] = "srg";
      dt.Rows.Add(dr);
      DataRow dr1 = dt.NewRow();
      dr1["ID"] = 2;
      dr1["Name"] = "cdf";
      dt.Rows.Add(dr1);  GridView1.DataSource = dt;
      GridView1.DataBind();
        
        
      }
      

  7.   

    GridView1.DataSource = datatable.deafultview;
    GridView1.DataBind();
      

  8.   

    this.gridview1`.datasource=dt;
    this.gridview1.databind();
      

  9.   

    GridView 控件可绑定到数据源控件(如 SqlDataSource、ObjectDataSource 等等),以及实现 System.Collections.IEnumerable 接口的任何数据源(如 System.Data.DataView、System.Collections.ArrayList 或 System.Collections.Hashtable)若要绑定到某个数据源控件,请将 GridView 控件的 DataSourceID 属性设置为该数据源控件的 ID 值。GridView 控件自动绑定到指定的数据源控件若要绑定到某个实现 System.Collections.IEnumerable 接口的数据源,请以编程方式将 GridView 控件的 DataSource 属性设置为该数据源,然后调用 DataBind 方法。如DataTableGridView1.DataSource = datatable.deafultview;
    GridView1.DataBind();
      

  10.   

     con.Open();
                OleDbCommand c = new OleDbCommand(str, con);
                OleDbDataAdapter oda = new OleDbDataAdapter(c);
                DataSet ds = new DataSet();
                oda.Fill(ds, "table1");
                this.GridView1.DataSource = ds.Tables["table1"];
                this.GridView1.DataBind();
                c.Dispose();
                con.Close();
      

  11.   

    GridView1.DataSource = datatable.deafultview;
    GridView1.DataBind();
      

  12.   

    GridView1.DataSource = dt;
    GridView1.DataBind();
      

  13.   

    DataTable dt=new DataTable();
    DataColumn dc=new DataColumn();
    dc.ColumnName="标题"; //这里最好用E文
    dt.Columns.Add(dc); //把该列加入到表格dt中
    DataColumn dc1=new DataColumn();
    dc.ColumnName="介绍";
    dt.Columns.Add(dc1); //把该列加入到表格dt中 ,其它要添加的列相同方式//如果你有好多数据,就在这里循环建
    DataRow row=dt.NewRow();
    row["标题"]=txtTit.Text;
    row["介绍"]=txtDes.Text;
    dt.Rows.Add(row);   //行加入至表格中
    GridView1.DataSource = dt;  //绑定表格到GridView
    GridView1.DataBind();