在gridview中遇到问题 [英] having problem in gridview

问题描述

我已经制作了gridview，然后右边的代码从数据库中获取数据。

但是这只显示gridview和列名称没有数据

请帮助我。

i have make gridview from and then right the code to take the data from database.
but this is only showing gridview and column name bu there is no data
please help me with that.

<asp:GridView ID="GridView1" runat="server"

           onrowcommand="GridView1_RowCommand" onrowdeleted="GridView1_RowDeleted"

           onrowediting="GridView1_RowEditing" onrowupdated="GridView1_RowUpdated"

           onselectedindexchanged="GridView1_SelectedIndexChanged"

           AutoGenerateColumns="False" onrowcreated="GridView1_RowCreated"

           style="margin-bottom: 0px">
           <Columns>
           <asp:TemplateField HeaderText="Rack No">
           <EditItemTemplate>
               <asp:TextBox ID="TextBoxEditrackno" runat="server" Text='<%# Bind("rackno") %>'/>
           </EditItemTemplate>
           <%--<ItemTemplate>
               <asp:Label ID="LabelRackNo" runat="server" Text='<%# Bind("Rack No") %>'/>
           </ItemTemplate>--%>
           <FooterTemplate>
               <asp:TextBox ID="TextBoxrackno" runat="server"/>
           </FooterTemplate>
       </asp:TemplateField >
       <asp:TemplateField HeaderText="Rack Name">
           <EditItemTemplate>
               <asp:TextBox ID="TextBoxEditrname" runat="server" Text='<%# Bind("rname") %>'/>
           </EditItemTemplate>
           <%--<ItemTemplate>
               <asp:Label ID="Labelrname" runat="server" Text='<%# Bind("rname") %>'/>
           </ItemTemplate>--%>
           <FooterTemplate>
               <asp:TextBox ID="TextBoxrname" runat="server"/>
           </FooterTemplate>
       </asp:TemplateField >
       <asp:TemplateField HeaderText="Quantity">
           <EditItemTemplate>
               <asp:TextBox ID="TextBoxEditqty" runat="server" Text='<%# Bind("qty") %>'/>
           </EditItemTemplate>
           <%--<ItemTemplate>
               <asp:Label ID="Labelqty" runat="server" Text='<%# Bind("qty") %>'/>
           </ItemTemplate>--%>
           <FooterTemplate>
               <asp:TextBox ID="TextBoxrqty" runat="server"/>
           </FooterTemplate>
       </asp:TemplateField >

b / b










< br $> b $ b

protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                binddata();
            }

        }
        private void binddata()
        {
            string connstring = @"Data Source=LENOVO-41B3F2CE\SQLEXPRESS;Initial Catalog=IMS;Integrated Security=True;Pooling=False";
            string query = "SELECT * FROM ['ISB VAS Nodes$']";
            SqlDataAdapter da = new SqlDataAdapter(query, connstring);
            DataTable dt = new DataTable();
            da.Fill(dt);
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }

推荐答案

'];
SqlDataAdapter da = new SqlDataAdapter（query，connstring）;
DataTable dt = new DataTable（）;
da.Fill（ dt）;
GridView1.DataSource = dt;
GridView1.DataBind（）;
}

']"; SqlDataAdapter da = new SqlDataAdapter(query, connstring); DataTable dt = new DataTable(); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); }

hi，



从项目模板中删除评论

Remove comment from item template

这篇关于在gridview中遇到问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！