problem in bind a gridview column for boolean field when no data present

See more:

C#

ASP.NET

hello all,


I am filling my gridview when no data is present, but in a field named "active", is a bit datatype , showing error "

Object cannot be cast from DBNull to other types

"

code for .aspx:-

<asp:GridView CssClass="maingrid" runat="server" ID="Grid1"
        AutoGenerateColumns="False" ShowFooter="true" DataKeyNames="id"
        onrowdeleting="Grid1_RowDeleting" onrowcommand="Grid1_RowCommand" >
    <HeaderStyle CssClass="headergrid"/>
    <FooterStyle CssClass="footergrid" />

    <Columns>
    <asp:TemplateField HeaderText="S.No.">
    <ItemTemplate>

    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Edit/Remove">
    <ItemTemplate>
    <asp:LinkButton runat="server" ID="btnDelete" CommandName="Delete" Text="Delete"></asp:LinkButton>
    </ItemTemplate>
    <FooterTemplate>
    Insert new kit
    </FooterTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Product Code">
    <ItemTemplate>
    <asp:Label runat="server" ID="lblProductCode" Text='<%#Eval("product_code") %>'></asp:Label>
    </ItemTemplate>
    <FooterTemplate>
    <asp:Button runat="server" ID="btnInsert" Text="Insert" CommandName="Insert" />
    </FooterTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Name">
    <ItemTemplate>
    <asp:Label runat="server" ID="lblName" Text='<%#Eval("name") %>'></asp:Label>
    </ItemTemplate>
    <EditItemTemplate>
    <asp:TextBox runat="server" ID="txtName1" Text='<%#Eval("name") %>'></asp:TextBox>
    </EditItemTemplate>
    <FooterTemplate>
    <asp:TextBox runat="server" ID="txtName"></asp:TextBox>
    </FooterTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="MRP">
    <ItemTemplate>
    <asp:Label runat="server" ID="lblMRP" Text='<%#Eval("mrp") %>'></asp:Label>
    </ItemTemplate>
    <EditItemTemplate>
    <asp:TextBox runat="server" ID="txtMRP1" Text='<%#Eval("mrp") %>'></asp:TextBox>
    </EditItemTemplate>
    <FooterTemplate>
    <asp:TextBox runat="server" ID="txtMRP"></asp:TextBox>
    </FooterTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Status">
    <ItemTemplate>
      <%#Convert.ToBoolean(DataBinder.Eval(Container, "DataItem.active")) ? "<img src='../images/active.gif'>" : "<img src='../images/deactive.gif'>"%>
    </ItemTemplate>
    <EditItemTemplate>
    <asp:CheckBox runat="server" ID="chkStatus" Text="Active" />
    </EditItemTemplate>
    <FooterTemplate>
    <asp:CheckBox runat="server" ID="chkStatus" />
    </FooterTemplate>
    </asp:TemplateField>
    </Columns>
    </asp:GridView>

code for .cs page:-

private void ShowNoResultFound(DataTable source, GridView gv)
  {
      source.Rows.Add(source.NewRow());
      gv.DataSource = source;
      gv.DataBind();
      int columnsCount = gv.Columns.Count;
      gv.Rows[0].Cells.Clear();
      gv.Rows[0].Cells.Add(new TableCell());
      gv.Rows[0].Cells[0].ColumnSpan = columnsCount;
      gv.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
      gv.Rows[0].Cells[0].ForeColor = System.Drawing.Color.Red;
      gv.Rows[0].Cells[0].Text = "NO RESULT FOUND!";
  }

error occur at gv.DataBind() event..