how to show true false in place of 1 and 0 froma tinyint col

Hi,
        If you are sure that your column value will be always contain either 0 or 1, then I suggest first change the datatype from tinyint to bit. Reason, in tinyint datatype it can store other than 0 and 1, but not in bit data type.
Then in your grid just use like this


if you want also in your datatable then, while reading the data use convert

LblTempText=Convert.ToBoolean(reader["YourColumnName"])



Regards,
Iftikar

no need change anything in datatable you can directly do it in gridview . plz share your code i will check that

i want to show true and false in data table of .net not in sqlserver table, so that it becomes  bool , in my case it is tinyint becasue in sqlserver table i have the col tiny int.
i do not want to change the col type in sqlserver nor do i want to change the query.

only thing i can do is do some changes, conversion in page (PL)

in page i have datatable of .net and grid view
so please tel me some means of changing the type in datatable and showing true and false in gridview keeping the type bool.

yours sincerely

hi,
you can do it in grid bind in item template like this in asp.net


 
 
 
 
  Text='<%# (bool)Eval("Status")?"True":"False" %>'>
 
 
 
 


if you want in windows form try this:


You can use the CellFormatting event of the DataGridView, e.g.:

void dataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
    var grid = (DataGridView)sender;
    if (grid.Columns[e.ColumnIndex].Name == "Status")
    {
        e.Value = (bool)e.Value ? "True" : "False";
        e.FormattingApplied = true;
    }
}

you want to show true/false in SQL server datatable  as well as in your grid view ...is it right?