Generate number

Question

I want to Generate Code from SQL server to C# application ! like if i type code 5 in my sql table than start numbers in C# application with 00001

Joginder Banger · Answer

i assume sql return the 3 value so application start number 001. int sqlnumber=3; //create a function... public int retunrNumber(int number) { string tempnumber=; for(int i=1;i { if(i!=number) { tempnumber+=0; } else { tempnumber+=1; } } return convert.Int32(tempnumber); }