modifying dataset values [modified]
-
hi all, in my dataset i have values like this (first row belongs to column names) AccountName RemarkCode RemarkCount Comapany Count Albert D32 1 AETNA 1 Albert N65 2 Medicaid 1 albert N65 1 MegaLife 1 raj 123 2 MegaLife 1 raj 123 2 Anthem 1 what i want is AccountName RemarkCode RemarkCount Comapany Count Albert D32 1 AETNA 1 ------ N65 1 Medicaid 1 ------ 49ps 1 MegaLife 1 raj 123 2 MegaLife 1 ----- ------ ----- Anthem 1 (---- represents no value at that place) an output like this can any body help me how to do this and i should display the out in a datagrid Thanx in advance your peter -- modified at 10:08 Saturday 8th July, 2006
-
hi all, in my dataset i have values like this (first row belongs to column names) AccountName RemarkCode RemarkCount Comapany Count Albert D32 1 AETNA 1 Albert N65 2 Medicaid 1 albert N65 1 MegaLife 1 raj 123 2 MegaLife 1 raj 123 2 Anthem 1 what i want is AccountName RemarkCode RemarkCount Comapany Count Albert D32 1 AETNA 1 ------ N65 1 Medicaid 1 ------ 49ps 1 MegaLife 1 raj 123 2 MegaLife 1 ----- ------ ----- Anthem 1 (---- represents no value at that place) an output like this can any body help me how to do this and i should display the out in a datagrid Thanx in advance your peter -- modified at 10:08 Saturday 8th July, 2006
Hi Peter, If I am clear about your problem the following solution might be helpful. Use the "Item_Databound" event of the DataGrid to check for the columns NULL or Empty values and update that column value with the required string say (----) in the corresponding DataTable (DataSet). The Item_Databound event fires for each and every row in the DataTable when getting binded to the DataGrid. Good Luck. Subrahmanyam K