在按钮上单击GridView不显示数据 [英] On button Click GridView is not Displaying Data

问题描述

设计页面



< asp：Button ID =btnReport1runat =serverText =Report 1Width =83pxOnClick = btnReport1_Click/>

Design Page

<asp:Button ID="btnReport1" runat="server" Text="Report 1" Width="83px" OnClick ="btnReport1_Click"/>

<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" AutoGenerateColumns ="true" ViewStateMode="Enabled">
                       
                    </asp:GridView>

编码页

Coding Page

Protected Sub btnReport1_Click(sender As Object, e As EventArgs) Handles btnReport1.Click
        Using conn1 As New SqlConnection(ConfigurationManager.ConnectionStrings("TERAMSConnectionString").ConnectionString)
            conn1.Open()
            Dim cmd As SqlCommand = New SqlCommand("Select * from Excel_table", conn1)
            Dim da As DataAdapter = New SqlDataAdapter(cmd)
            Dim dt As DataSet = New DataSet
            da.Fill(dt)
            GridView1.DataSource = dt
            GridView1.DataBind()
            conn1.Close()
        End Using
    End Sub

推荐答案

我没有'解决简单的方法，最后我不得不在设计页面中使用项目模板，但我仍觉得它不那么有效。

I didn't solve the simple way and finally i had to use "Item Template" in the design page but i still feel its not that effective.

<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" AllowPaging="True"
        AllowSorting="True" CellPadding="4" ForeColor="#333333" GridLines="None" OnPageIndexChanging ="GridView2_PageIndexChanging" Width="245px">
                  <AlternatingRowStyle BackColor="White" />
            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                        <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
            <SortedAscendingCellStyle BackColor="#FDF5AC" />
            <SortedAscendingHeaderStyle BackColor="#4D0000" />
            <SortedDescendingCellStyle BackColor="#FCF6C0" />
            <SortedDescendingHeaderStyle BackColor="#820000" />
                  <Columns>
                <asp:TemplateField HeaderText="HostName">
                <ItemTemplate>
                    <%# Eval("HostName")%>
                </ItemTemplate>
            </asp:TemplateField>
                      <asp:TemplateField HeaderText="Serial Number">
                <ItemTemplate>
                    <%# Eval("SerialNo")%>
                </ItemTemplate>
            </asp:TemplateField>
                  </Columns>
              </asp:GridView>

这篇关于在按钮上单击GridView不显示数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！