Object cannot be cast from DBNull to other types
<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>
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!"; }
IsNull(active,0) as active
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)