Hi i'm new to ASP.NET

Please help me with the following problem.

I have the column by name 'Role' in my Datagrid. This column should display the role of employees either as 'Leader' or 'Member' based on the value retrieved from the database. The value i retrieve is 'Y' or 'N'. So if the value is 'Y', then the column should display as 'Leader' otherwise as 'Member'.

How can i make it up!!

Kindly Suggest!!

Thanks in advance!!:)

i think u r using dataset to bind the datagrid..

before assigning datasource to the dataset [ 'DataGrid1.DataSource = ds']
u have to check the value y or N.

just add this line before setting datasource to dataset

just spcify the column index as item.. if 'Y' returned as column 3 means u can specify item(3)

if(ds.tables(0).rows(0),items(0)='Y')
     ds.tables(0).rows(0),items(0)='Leader'
else
     ds.tables(0).rows(0),items(0)='Member'
endif

DataGrid1.DataSource = ds
ds.databind



if u have returned more than one row from DB, u can make a loop and do it..

===========
Ram

Ram has told the correct way and I will too suggest the same way for
doing this stuff

rajkumar sharma

Hi all,

if you are using sql server then just put case statement in your select query to create a derived column and give an alias to your derived column. Inthis way you will save extra time to parse the data and change the column values. For details , consult Sql server help for use of case statement in select queries.
I hope it will help you

Anubhav Kumar

thats better time.. it reduces lots of time in fron end

====
Ram