Row Data Bound in ASP.NET Grid View C#

I have a grid view and need to bind IsActive field.But from the database it comes as 1 or 0.

Error shows System.InvalidCastException: 'Specified cast is not valid.'

Grid

<asp:BoundField DataField="IsActive" HeaderText="Status">
                                    <ItemStyle Width="200px" />
                                </asp:BoundField>

Code

 protected void grid1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            if (((int)DataBinder.Eval(e.Row.DataItem, "IsActive") == 1))
            {
                e.Row.Cells[12].Text = "Active";

            }
            else
            {
                e.Row.Cells[12].Text = "Inactive";
          }

        }
    }

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

Try grabbing the underlying data item first and then checking for it.

protected void grid1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    DataRowView rowView = null;
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        // Retrieve the underlying data item 
        rowView = (DataRowView)e.Row.DataItem;

        // Make sure we can parse and compare what we get.
        if (int.TryParse(rowView["IsActive"].ToString(), out int isActive) && isActive == 1)
        {
            e.Row.Cells[12].Text = "Active";

        }
        else
        {
            e.Row.Cells[12].Text = "Inactive";
        }

    }
}

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0