1
Answer

Pwd and Unique ID Generation ...

suren v

suren v
10y
879
1
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)
Next Recommended Forum