TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Venkata Subbareddy
980
725
97.8k
How to generate the Autounique id
May 27 2015 12:14 PM
hi friends,
Iam develop the student Registration form here student Click the Location in dropdown value generate the User Id based on location suppose
student click Hyderbad -------> userid = Hyd001
student Click Hyderbad -------> user id = Hyd002
student Click chennai -----------> user id = che001 next student click increment the value....
in the below iam writing the code where iam doing wrong please let me know....
protected void dpCity_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=SERVER;Initial Catalog=MuraliIIT;User ID=sa;Password=rits@1234");
string s = "select count(*) from NewStudentRegistrationForm where City ='" + dpCity.SelectedItem.Value + "'";
con.Open();
SqlCommand com = new SqlCommand(s, con);
int count = Convert.ToInt32(com.ExecuteScalar());
string city = dpCity.SelectedItem.Value;
string GeneratedId= "";
count+= 1;
if (count < 10)
GeneratedId = dpCity + "00" + count.ToString();
else if (count < 100)
GeneratedId = dpCity + "0" + count.ToString();
else
GeneratedId = dpCity + count.ToString();
TxtUserid.Text=GeneratedId;
}
Reply
Answers (
3
)
How to Generate Based on Location AutoGenerate Number using
Microsoft's programming Languages