suren v

suren v

  • NA
  • 113
  • 43.6k

Pwd and Unique ID Generation ...

Sep 30 2014 3:00 AM
Hai Friends,

              I need your suggestions. I have table in DB like this. 
Step1:
DepT_ID          Unique_Id             Pwd
IT1                  
IT2                  
IT3    
              
I want to create unique id with pwd generation like this. 
At a time i just select these three Different Department Id in Gridview and click Ok button means then automatically  generate the unique id and pwd  below like this. 
  
Step2:
DepT_ID          Unique_Id            Pwd
IT1                  140930W001         ASDF
IT2                  140930W001         ASDF      
IT3                  140930W001         ASDF       

I need this solution in Oracle or SQL or C# coding. Plz suggest me one good solution. 

Thanks In Advance Friends,






Answers (1)