data replacing in gridview

Question

Hi, I am working in ASP.Net, i am saving the status field in database as true or false. Now i want to display the true or false as active or inactive in the front end in gridview. How to display the data in gridview.

Can anyone know please reply me..

Thanks in advance.

Answer 1

If you're asking how to change true and false to Active and Inactive, you could use a CASE statement in your SQL query, like this:

SELECT CASE Status WHEN 1 THEN 'Active' WHEN 0 THEN 'Inactive' END FROM Something

For a more specific answer, please post more details.

Answer 2

use checkbox column to show the status field. ( set that column to disable )

Answer 3

The alternative is to use your datagrid's RowDataBound event to convert what is it to the strings active / inactive:

  Protected Sub gvRequests_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvRequests.RowDataBound
        If e.Row.RowType = DataControlRowType.DataRow Then
            Dim lbl As Label = CType(e.Row.FindControl("lblStatus"), Label)
            If lbl.Text="1" then
                   lbl.Text="Active"
            else
                   lbl.Text="Inactive"
            end if
        end if
  end sub

Answer 4

If you know the cell location of which you want to filter data, you could also do this in the gridviews RowDataBound event.

protected void gv_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            if (e.Row.Cells[2].Text == "1")
                e.Row.Cells[2].Text = "True";
            else
                e.Row.Cells[2].Text = "False";
        }
    }

This is what I used to find and replace text in a gridview.