Solved

Can't set the Header Text in my GridView in ASP.NET C#

Posted on 2013-06-24
9
680 Views
Last Modified: 2013-06-25
I am using ASP.NET 4.0 C# and am trying to programmatically set the Header Text for the GridView on my page.  I am getting an Index was out of range error and can't figure out what I am doing wrong.  Here is the GridView on my page:

            <p><b>Warnings</b></p>
            <asp:GridView ID="gvWarnings" runat="server">
            </asp:GridView>

Open in new window


And here is the code where I am trying to set the HeaderText:

                gvWarnings.DataSource = dtWarnings;
                gvWarnings.CellPadding = 3;
                gvWarnings.CellSpacing = 3;
                gvWarnings.Columns[0].HeaderText = "Warning";
                gvWarnings.Columns[1].HeaderText = "Date";
                gvWarnings.Columns[2].HeaderText = "Title";
                gvWarnings.DataBind();

Open in new window


dtWarnings is a datatable with 3 columns in it.  

Any help is greatly appreciated!
0
Comment
Question by:dyarosh
  • 6
  • 3
9 Comments
 
LVL 2

Expert Comment

by:eli411
ID: 39273390
You might have null records in your query!  I would recommand that you check null in your coding - put exception or something.
0
 

Author Comment

by:dyarosh
ID: 39273412
The table definitely has data.  It displays on the screen if I comment out the code where I am trying to set the Header Column Names.
0
 
LVL 2

Expert Comment

by:eli411
ID: 39273423
I know the table has data and you might have one missing records out from your table!  Have you check all individual rows using SQL script?
0
 
LVL 2

Expert Comment

by:eli411
ID: 39273425
what is your dtWarnings looks like in code behind or SQL script/stored procedure?  The index error meant that you either reference wrong columns or with some missing data!
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 2

Accepted Solution

by:
eli411 earned 500 total points
ID: 39273442
0
 

Author Comment

by:dyarosh
ID: 39273482
Here is the SQL:

            sql = "SELECT WarningType, WarningDate, TitleDesc " +
                  "FROM EMP_Warnings " +
                  "JOIN EMP_WarningType ON EMP_WarningType.WarningTypeID = EMP_Warnings.WarningTypeID " +
                  "WHERE EmployeeID = " + employeeID.ToString();
0
 

Author Closing Comment

by:dyarosh
ID: 39275254
I ended up setting the column headings in the RowDataBound event.  Thanks for the help.
0
 
LVL 2

Expert Comment

by:eli411
ID: 39275261
Here is how I coded my datagrid!

---------------------- aspx page ---------------------- (UserName from database column)

<tr>
     <td>
              <asp:datagrid id="dgTest" runat="server" OnPageIndexChanged="dgTest_OnPageIndexChanged">
                   <asp:TemplateColumn HeaderText="Name">
                          <ITEMTEMPLATE>
                                 <%#DataBinder.Eval(Container.DataItem,"UserName")%>
                          </ITEMTEMPLATE>
                   </asp:TemplateColumn>
              </asp:datagrid>
     </td>
</tr>

------------------------- code behind page ------------------------
public void dgTest_OnPageIndexChanged(Object sender, DataGridItemEventArgs e)
{
    ---- open db connection ---
    .....
    ---- select sql syntax here

}
0
 
LVL 2

Expert Comment

by:eli411
ID: 39275268
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now