Could any one help me to perform Below task with DataSet. RRS feed

  • General discussion

  • I have my data in dataSet. DataTable has many columns like Code, AlternateCode, Modefier, Adress,City,State,Zip.....

    Code      AlternateCode  Modefier

    11101    11101               25

    11101    11101                OB

    11101  11101                 

    11200    11200       

    11200   11200      05  

     I want perform below task with the data in the dataset. I want to modify the AltCode like below.

    Code AlternateCode Mod
    11101 11101 //one Code should be equilent to AlternteCode
    11101  11101 -25 25 //If modifier exsists it should be added to code
    to make alternate code only when there is equilent
     alternate code exsist for the code.
    11101 11101-OB OB
    11200  11200  25 //AltCode is not added with modifier is bcs there is
    no Alternate code same as Current CPT
    11200   11200 -85 85 //Modifier value is added to Cpt code to make
     AltCode is bcs equilent for the code exsists.


    Shine pearl
    Friday, December 9, 2011 7:25 AM

All replies


    Could you please clarify your problem in details? I didn't understand the problem. I think I can help you more effective if you can clarify more clearly.

    Best Regards

    Allen Li [MSFT]
    MSDN Community Support | Feedback to us
    Monday, December 12, 2011 8:32 AM