Bind gridview when column not exists in datatable but binding at itemtemplate

Question

0.00/5 (No votes)

See more:

I am having a dataset which i am pivoting and then binding to a grid view. It is working fine when all the itemtemplates value are present in the pivoted table but in case if any of the column is not present in the pivoted table, then at the time of binding the gridview , i am getting error . Please help me that how i will handle it in grid view if any of the columns is not present but i am binding it to grid view itemtemplate. Below is my grid view code.

ASP.NET

<asp:GridView ID="gvCoreUtilization" runat="server" BackColor="White" BorderColor="#cEcFcE"
                        BorderStyle="Solid" BorderWidth="1px" CellPadding="4" ForeColor="Black" OnRowCreated="grdPivot3_RowCreated"
                        AutoGenerateColumns="false" OnRowDataBound="grdCoreUtilization_RowDataBound">
                        <RowStyle BackColor="#F7F7DE" />
                        <FooterStyle BackColor="#CCCC99" />
                        <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
                        <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
                        <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" HorizontalAlign="Left" />
                        <AlternatingRowStyle BackColor="White" />
                        <Columns>
                            <asp:TemplateField>
                                <ItemTemplate>
                                    <asp:Label ID="lblRoleID" Text='<%#Eval("RoleId") %>' runat="server" Visible="false"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField>
                                <HeaderTemplate>
                                    SupervisorName
                                </HeaderTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblSupervisorName" Text='<%#Eval("SupervisorName") %>' runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField>
                                <HeaderTemplate>
                                    UserECode
                                </HeaderTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblUserECode" Text='<%#Eval("UserECode") %>' runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField>
                                <HeaderTemplate>
                                    UserName
                                </HeaderTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblUserName" Text='<%#Eval("UserName") %>' runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField>
                                <HeaderTemplate>
                                    Designation
                                </HeaderTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblDesignation" Text='<%#Eval("Designation") %>' runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField>
                                <HeaderTemplate>
                                    L & D Training%
                                </HeaderTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblLDTraining" Text='<%#Eval("L & D Training%") %>' runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField>
                                <HeaderTemplate>
                                    Non Production%
                                </HeaderTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblNonProduction" Text='<%#Eval("Non Production%") %>' runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField>
                                <HeaderTemplate>
                                    Process Support%
                                </HeaderTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblProcessSupport" Text='<%#Eval("Process Support%") %>' runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField>
                                <HeaderTemplate>
                                    Process Training%
                                </HeaderTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblProcessTraining" Text='<%#Eval("Process Training%") %>' runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField>
                                <HeaderTemplate>
                                    Production%
                                </HeaderTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblProduction" Text='<%#Eval("Production%") %>' runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField>
                                <HeaderTemplate>
                                    System Downtime%
                                </HeaderTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblSystemDowntime" Text='<%#Eval("System Downtime%") %>' runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField>
                                <HeaderTemplate>
                                    Grand Total%
                                </HeaderTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblGrandTotal" Text='<%#Eval("Grand Total%") %>' runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                        </Columns>
                    </asp:GridView>

Actually "L & D Training%","Non Production%","Process Support%","Process Training%","Production%","System Downtime%","Grand Total%" are the pivoted columns which i am binding to itemtemplate .For some User few of these column are not present and while binding the grid i am getting error

Posted 2-May-13 19:09pm

Dharmenrda Kumar Singh

Updated 2-May-13 19:20pm

v2

Add a Solution

Comments

Thanks7872 3-May-13 1:56am

Show your code file.Mention clearly at which line you are getting error?whats the error?

3 solutions

Solution 2

Bind these values in Rowdatabound of grid view
Sample code is show below

C#

protected void grdAyurvedic_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                 Label lbl = (Label)e.Row.FindControl("LabelId");
                 lbl.Text = "Text";
            }

    }

Posted 2-May-13 20:06pm

Jithin Geroge

Solution 3

C#

// ---- GetColumnIndexByHeaderText ----------------------------------
        //
        // pass in a GridView and a Column's Header Text
        // returns index of the column if found
        // returns -1 if not found 
    
    
        static public int GetColumnIndexByHeaderText(GridView aGridView, String ColumnText)
        {
            TableCell Cell;
            for (int Index = 0; Index < aGridView.HeaderRow.Cells.Count; Index++)
            {
                Cell = aGridView.HeaderRow.Cells[Index];
                if (Cell.Text.ToString() == ColumnText)
                    return Index;
            }
            return -1;
        }
    
    
        // ---- GetColumnIndexByDBName ----------------------------------
        //
        // pass in a GridView and a database field name
        // returns index of the bound column if found
        // returns -1 if not found 
    
    
        static public int GetColumnIndexByDBName(GridView aGridView, String ColumnText)
        {
            System.Web.UI.WebControls.BoundField DataColumn;
    
    
            for (int Index = 0; Index < aGridView.Columns.Count; Index++)
            {
                DataColumn = aGridView.Columns[Index] as System.Web.UI.WebControls.BoundField;
    
    
                if (DataColumn != null)
                {
                    if (DataColumn.DataField == ColumnText)
                        return Index;
                }
                }
            return -1;
        }

Reference: http://forums.asp.net/p/1095706/1653611.aspx#1653611[^]

Posted 3-Feb-14 23:20pm

Absials

Updated 3-Feb-14 23:39pm

v2

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)

vijay__p · Accepted Answer · 2013-05-02T19:56:00

Don't directly bind using Eval in design view instead of that You can bing data in RowDataBound event

So in RowDataBound event find label from Grid and also DataBind column from data source
If column available then bind it with label as leave it as it is.

If you are using DataTable for DataSource then you can use below code to check whether given column/property is exists or not in RowDataBound event.

C#

var dataRow = (DataRowView)e.Row.DataItem;
               var columnNameToCheck = "Id";
               var check = dataRow.Row.Table.Columns.Cast<DataColumn>().Any(x => x.ColumnName.Equals(columnNameToCheck, StringComparison.InvariantCultureIgnoreCase));
               if (check)
               {
                   // Property available
               }

Here, columnNameToCheck is variable to hold property name to check whether it is exists in data source or not.