Merging Columns in One Column

raafishaafi · #1 (**permalink**) 01-14-2009, 2:52 PM

Hey,
I have a requirement, If in datatable the value of one column is null. I gotta show the value of other column in the same column.

For example:

Code:

id | name | descript | descriptionType
1  | ab   |          |    doc 
2  | pd   | pdf      |
3  | cd   |          |   Business

Result should be

Code:

id name descript
1 ab       doc
2 pd       pdf
3 cd       business.

Thanks in advance.

Stonkie · #2 (**permalink**) 01-14-2009, 6:59 PM

You can modify your SQL SELECT statement like this :

Code:

SELECT Id, Name, ISNULL(Descript, descriptionType) AS Description

I you need the user to save this data though, you may have to keep two separate data models. A better idea might be to modify the data as it is displayed, but I do not have enough experience with Web Forms to help you out on this.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)