Can I convert a boolean to Yes No in a ASP NET GridView

Question

I have a ASP NET GridView with a column mapped to a boolean  I want do display  Yes   No  instead of  True   False   Well actually I want  Ja   Nej   in Danish    Is this possible     lt asp gridview id  GridView1  runat  server  autogeneratecolumns  false  gt       lt columns gt                       lt asp boundfield headertext  Active  datafield  Active  dataformatstring   0 Yes No     gt                   lt  columns gt   lt  asp gridview gt

User · Answer

This is how I ve always done it    lt ItemTemplate gt     lt    Boolean Parse Eval  Active   ToString       Yes     No    gt   lt  ItemTemplate gt    Hope that helps

User · Answer

Or you can use the ItemDataBound event in the code behind

User · Answer

Or you can use the ItemDataBound event in the code behind

User · Answer

I had the same need as the original poster  except that my client s db schema is a nullable bit  ie  allows for True False NULL    Here s some code I wrote to both display Yes No and handle potential nulls   Code-Behind   public string ConvertNullableBoolToYesNo object pBool        if  pBool    null                return  bool pBool    Yes     No             else               return  No             Front-End    lt    ConvertNullableBoolToYesNo Eval  YOUR FIELD     gt

User · Answer

You could use a Mixin         lt summary gt      Adds  mixins  to the Boolean class       lt  summary gt  public static class BooleanMixins            lt summary gt          Converts the value of this instance to its equivalent string representation  either  Yes  or  No             lt  summary gt           lt param name  boolean  gt  lt  param gt           lt returns gt string lt  returns gt      public static string ToYesNoString this Boolean boolean                return boolean    Yes     No

User · Answer

Nope - but you could use a template column    lt script runat  server  gt    TResult Eval lt T  TResult gt  string field  Func lt T  TResult gt  converter         object o   DataBinder Eval Container DataItem  field        if  converter    null            return  TResult o              return converter  T o        lt  script gt    lt asp TemplateField gt     lt ItemTemplate gt        lt    Eval lt bool  string gt   Active   b   gt  b    Yes     No     gt     lt  ItemTemplate gt   lt  asp TemplateField gt

User · Answer

I use this code for VB    lt asp TemplateField HeaderText  Active  SortExpression  Active  gt       lt ItemTemplate gt  lt   IIf Boolean Parse Eval  Active   ToString      Yes    No    gt  lt  ItemTemplate gt   lt  asp TemplateField gt    And this should work for C   untested     lt asp TemplateField HeaderText  Active  SortExpression  Active  gt       lt ItemTemplate gt  lt     Boolean Parse Eval  Active   ToString        Yes     No    gt  lt  ItemTemplate gt   lt  asp TemplateField gt

User · Answer

This works   Protected Sub grid RowDataBound sender As Object  e As System Web UI WebControls GridViewRowEventArgs  Handles grid RowDataBound     If e Row RowType   DataControlRowType DataRow Then         If e Row Cells 3  Text    True  Then             e Row Cells 3  Text    Si          Else             e Row Cells 3  Text    No          End If     End If End Sub   Where cells 3  is the column of the column that has the boolean field

User · Answer

You could use a Mixin         lt summary gt      Adds  mixins  to the Boolean class       lt  summary gt  public static class BooleanMixins            lt summary gt          Converts the value of this instance to its equivalent string representation  either  Yes  or  No             lt  summary gt           lt param name  boolean  gt  lt  param gt           lt returns gt string lt  returns gt      public static string ToYesNoString this Boolean boolean                return boolean    Yes     No

User · Answer

Add a method to your page class like this   public string YesNo bool active       return active    Yes     No       And then in your TemplateField you Bind using this method    lt    YesNo Active    gt

User · Answer

It s easy with Format  -Function  Format aBoolean   YES NO     Please find details here  https   msdn microsoft com en-us library aa241719 v vs 60  aspx

User · Answer

You could use a Mixin         lt summary gt      Adds  mixins  to the Boolean class       lt  summary gt  public static class BooleanMixins            lt summary gt          Converts the value of this instance to its equivalent string representation  either  Yes  or  No             lt  summary gt           lt param name  boolean  gt  lt  param gt           lt returns gt string lt  returns gt      public static string ToYesNoString this Boolean boolean                return boolean    Yes     No

User · Answer

Add a method to your page class like this   public string YesNo bool active       return active    Yes     No       And then in your TemplateField you Bind using this method    lt    YesNo Active    gt

User · Answer

I use this code for VB    lt asp TemplateField HeaderText  Active  SortExpression  Active  gt       lt ItemTemplate gt  lt   IIf Boolean Parse Eval  Active   ToString      Yes    No    gt  lt  ItemTemplate gt   lt  asp TemplateField gt    And this should work for C   untested     lt asp TemplateField HeaderText  Active  SortExpression  Active  gt       lt ItemTemplate gt  lt     Boolean Parse Eval  Active   ToString        Yes     No    gt  lt  ItemTemplate gt   lt  asp TemplateField gt

User · Answer

You could use a Mixin         lt summary gt      Adds  mixins  to the Boolean class       lt  summary gt  public static class BooleanMixins            lt summary gt          Converts the value of this instance to its equivalent string representation  either  Yes  or  No             lt  summary gt           lt param name  boolean  gt  lt  param gt           lt returns gt string lt  returns gt      public static string ToYesNoString this Boolean boolean                return boolean    Yes     No

User · Answer

I had the same need as the original poster  except that my client s db schema is a nullable bit  ie  allows for True False NULL    Here s some code I wrote to both display Yes No and handle potential nulls   Code-Behind   public string ConvertNullableBoolToYesNo object pBool        if  pBool    null                return  bool pBool    Yes     No             else               return  No             Front-End    lt    ConvertNullableBoolToYesNo Eval  YOUR FIELD     gt

User · Answer

Add a method to your page class like this   public string YesNo bool active       return active    Yes     No       And then in your TemplateField you Bind using this method    lt    YesNo Active    gt

User · Answer

Or you can use the ItemDataBound event in the code behind

User · Answer

This is how I ve always done it    lt ItemTemplate gt     lt    Boolean Parse Eval  Active   ToString       Yes     No    gt   lt  ItemTemplate gt    Hope that helps

User · Answer

Nope - but you could use a template column    lt script runat  server  gt    TResult Eval lt T  TResult gt  string field  Func lt T  TResult gt  converter         object o   DataBinder Eval Container DataItem  field        if  converter    null            return  TResult o              return converter  T o        lt  script gt    lt asp TemplateField gt     lt ItemTemplate gt        lt    Eval lt bool  string gt   Active   b   gt  b    Yes     No     gt     lt  ItemTemplate gt   lt  asp TemplateField gt

User · Answer

Or you can use the ItemDataBound event in the code behind

User · Answer

Nope - but you could use a template column    lt script runat  server  gt    TResult Eval lt T  TResult gt  string field  Func lt T  TResult gt  converter         object o   DataBinder Eval Container DataItem  field        if  converter    null            return  TResult o              return converter  T o        lt  script gt    lt asp TemplateField gt     lt ItemTemplate gt        lt    Eval lt bool  string gt   Active   b   gt  b    Yes     No     gt     lt  ItemTemplate gt   lt  asp TemplateField gt

User · Answer

I use this code for VB    lt asp TemplateField HeaderText  Active  SortExpression  Active  gt       lt ItemTemplate gt  lt   IIf Boolean Parse Eval  Active   ToString      Yes    No    gt  lt  ItemTemplate gt   lt  asp TemplateField gt    And this should work for C   untested     lt asp TemplateField HeaderText  Active  SortExpression  Active  gt       lt ItemTemplate gt  lt     Boolean Parse Eval  Active   ToString        Yes     No    gt  lt  ItemTemplate gt   lt  asp TemplateField gt

User · Answer

It s easy with Format  -Function  Format aBoolean   YES NO     Please find details here  https   msdn microsoft com en-us library aa241719 v vs 60  aspx

User · Answer

Add a method to your page class like this   public string YesNo bool active       return active    Yes     No       And then in your TemplateField you Bind using this method    lt    YesNo Active    gt

User · Answer

I use this code for VB    lt asp TemplateField HeaderText  Active  SortExpression  Active  gt       lt ItemTemplate gt  lt   IIf Boolean Parse Eval  Active   ToString      Yes    No    gt  lt  ItemTemplate gt   lt  asp TemplateField gt    And this should work for C   untested     lt asp TemplateField HeaderText  Active  SortExpression  Active  gt       lt ItemTemplate gt  lt     Boolean Parse Eval  Active   ToString        Yes     No    gt  lt  ItemTemplate gt   lt  asp TemplateField gt

User · Answer

This works   Protected Sub grid RowDataBound sender As Object  e As System Web UI WebControls GridViewRowEventArgs  Handles grid RowDataBound     If e Row RowType   DataControlRowType DataRow Then         If e Row Cells 3  Text    True  Then             e Row Cells 3  Text    Si          Else             e Row Cells 3  Text    No          End If     End If End Sub   Where cells 3  is the column of the column that has the boolean field

User · Answer

Nope - but you could use a template column    lt script runat  server  gt    TResult Eval lt T  TResult gt  string field  Func lt T  TResult gt  converter         object o   DataBinder Eval Container DataItem  field        if  converter    null            return  TResult o              return converter  T o        lt  script gt    lt asp TemplateField gt     lt ItemTemplate gt        lt    Eval lt bool  string gt   Active   b   gt  b    Yes     No     gt     lt  ItemTemplate gt   lt  asp TemplateField gt

[asp.net] Can I convert a boolean to Yes/No in a ASP.NET GridView

Examples related to asp.net

Examples related to gridview