How to make GridView Visible a browser.

Question

4.00/5 (1 vote)

See more:

I have a GridView on a form and it's not visible in the browser even though Visible has been set to True in the Property Window. Meanwhile, I have the following code to enable data to be visible in the columns of the GridView, but nothing seems to work for me. I'd be glad if someone could help me out.

The showgrid procedure is supposed to be called when the form is being loaded, but non of this is working. What beats me completely is the GrideView not showing even though it is visible in the Design view.

VB

Sub showgrid()
     Try
         ds.Clear()
         ada = New SqlDataAdapter("Select SubjectCode'Subject Code',SubjectName'Subject Name',SubjectType'Subject Type',UserId'User Id',Password from ProgramDetails.Subjects", cn)
         ada.Fill(ds, "ProgramDetails.Subjects")
         cmd = New SqlCommand("Select SubjectCode'Subject Code',SubjectName'Subject Name',SubjectType'Subject Type',UserId'User Id',Password from ProgramDetails.Subjects", cn)
         ada.SelectCommand = cmd
         ada.Fill(ds)
         GridView1.DataSource = ds.Tables(0)
     Catch ex As Exception
     End Try
End Sub

ASP code

HTML

<html xmlns="http://www.w3.org/1999/xhtml">
<head  runat="server">
    <title>Untitled Page</title>
    <style type="text/css">
        .style2
        {
        }
        .style4
        {
            width: 297px;
        }
        .style6
        {
            width: 268px;
        }
        .style3
        {
            height: 23px;
            width: 146px;
        }
        .style5
        {
            height: 23px;
            width: 297px;
        }
        .style1
        {
            height: 23px;
            width: 268px;
        }
        .style7
        {
        }
    </style>
</head>
<body>
    <form id="frmSubjects"  runat="server">
    <asp:Panel ID="Panel1" runat="server" BackColor="#FFFF99" BorderColor="#00CC00" 
        BorderStyle="Double" Height="464px">
        <div>
        </div>
        <p>
            <asp:TextBox ID="txtIdNumber" runat="server" Visible="False" 
            Width="26px"></asp:TextBox>
        </p>
        <table style="width: 66%;" align="center">
            <tr>
                <td class="style2" colspan="2">
                    Subject Code</td>
                <td class="style4" colspan="2">
                    <asp:TextBox ID="txtSubjectCode" runat="server"></asp:TextBox>
                </td>
                <td class="style6" colspan="2">
                    <asp:Button ID="btnGridView" runat="server" style="text-align: center" Text="Save" 
                    Width="93px" />
                </td>
            </tr>
            <tr>
                <td class="style3" colspan="2">
                    Subject Name</td>
                <td class="style5" colspan="2">
                    <asp:TextBox ID="txtSubjectName" runat="server" Width="279px"></asp:TextBox>
                </td>
                <td class="style1" colspan="2">
                </td>
            </tr>
            <tr>
                <td class="style2" colspan="2">
                    Subject Type</td>
                <td class="style4" colspan="2">
                    <asp:RadioButton ID="rbnCore" runat="server" Text="Core" />
                    <asp:RadioButton ID="rbnElective" runat="server" Text="Elective" />
                </td>
                <td class="style6" colspan="2">
                     </td>
            </tr>
            <tr>
                <td class="style2" colspan="2">
                    Enter User Name</td>
                <td class="style4" colspan="2">
                    <asp:TextBox ID="txtUserId" runat="server"></asp:TextBox>
                </td>
                <td class="style6" colspan="2">
                     </td>
            </tr>
            <tr>
                <td class="style2" colspan="2">
                    Enter Password</td>
                <td class="style4" colspan="2">
                    <asp:TextBox ID="txtPassword" runat="server"></asp:TextBox>
                </td>
                <td class="style6" colspan="2">
                     </td>
            </tr>
            <tr>
                <td class="style7">
                    <asp:Button ID="btnSave" runat="server" style="text-align: center" Text="Save" 
                    Width="93px" />
                </td>
                <td class="style2" colspan="2">
                    <asp:Button ID="btnClear" runat="server" Text="Clear" Width="92px" />
                </td>
                <td class="style2" colspan="2">
                    <asp:Button ID="btnUpdate" runat="server" Text="Update" Width="96px" />
                </td>
                <td class="style2">
                    <asp:Button ID="btnDelete" runat="server" Text="Delete" Width="97px" />
                </td>
            </tr>
            <tr>
                <td class="style7">
                     </td>
                <td class="style2" colspan="2">
                     </td>
                <td class="style2" colspan="2">
                     </td>
                <td class="style2">
                     </td>
            </tr>
            <tr>
                <td class="style7" colspan="6">
                    <asp:Label ID="lblMessage" runat="server" 
                    style="text-align: center" Text="Label"></asp:Label>
                </td>
            </tr>
        </table>
        <asp:GridView ID="GridView1" runat="server" CellPadding="4" 
    ForeColor="#333333" GridLines="None" 
        style="text-align: center" Width="491px">
            <RowStyle BackColor="#E3EAEB" />
            <EmptyDataRowStyle BorderStyle="Solid" />
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#7C6F57" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>
    </asp:Panel>
    <div>
    
    </div>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:NaassConnectionString %>" 
        SelectCommand="SELECT [IDNumber], [SubjectCode], [SubjectName], [SubjectType], [UserId], [Password] FROM [Subjects]">
    </asp:SqlDataSource>
    </form>
</body>
</html>

Posted 23-Mar-13 6:54am

Akaglo

Updated 23-Mar-13 7:39am

v3

Add a Solution

Comments

frostcox 23-Mar-13 13:35pm

Can you show your aspx code please?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 23-Mar-13 14:30pm

You have one sql datasource defined in the aspx page and again you are using DataAdapter to bind the GridView from code behind.
Why are you doing the same thing twice ?

Akaglo 23-Mar-13 16:39pm

I've removed the repeated line of code and what is happening is that the grid now appears but can't display data in columns

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Akaglo · Accepted Answer · 2013-03-23T12:20:00

VB

Try
            ds.Clear()
            ada = New SqlDataAdapter("Select SubjectCode'Subject Code',SubjectName'Subject Name',SubjectType'Subject Type',UserId'User Id',Password from ProgramDetails.Subjects", cn)
            ada.Fill(ds, "ProgramDetails.Subjects")
            cmd = New SqlCommand("Select SubjectCode'Subject Code',SubjectName'Subject Name',SubjectType'Subject Type',UserId'User Id',Password from ProgramDetails.Subjects", cn)
            ada.SelectCommand = cmd
            ada.Fill(ds)
            GridView1.DataSource = ds.Tables(0)
            GridView1.DataBind()'binds the datasource to the GridView
        Catch ex As Exception
        End Try