How to Generate the automatic userid based on Location

Venkata Subbareddy

Hi Good Morning Every Body,

How to Generate The automatically Userid based on Location using asp.net

Ex: my user Location Click Hyderabad her user id generate Hyd0001 and another user select the chennai her user id generate che0001 this my task Give me suggestions and reference source code...

17 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
Accepted answer
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=SERVER;Initial Catalog=MuraliIIT;User ID=sa;Password=rits@1234");
con.Open();
string s = "select count(*) from Test";
SqlCommand com = new SqlCommand(s, con);

int count = Convert.ToInt16(com.ExecuteScalar()) + 2;
txt1.Text = "E00" + count; con.Close();
}
S Sreelakshmi11y ago
After selecting dropdown value

in button click or dropdownselected index changed method use the following code

try
{
con.Open();
SqlCommand cmd = new SqlCommand("select max(cast (Code as int)) as id from Location", con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
j = Convert.ToInt16(dr["id"].ToString()) + 1;
}
else
{
j = 1;
}
}
catch (Exception ex)
{
j = 1;
}
finally
{
if (con.State == ConnectionState.Open)
con.Close();
}

Label.Text= droploc.SelectedValue.Trim()+j.ToString();

Try this its working fine...
Venkata Subbareddy11y ago
dp1.Text = "dp1.SelectedValue" + count.ToString(); corrct or wrong???
Upendra Pratap Shahi11y ago
kindly convert dropdown value in integer type then add count if you have want to dropdown value with addition of incremented value.
Venkata Subbareddy11y ago
prtap Bro... small Help. I need some information iam writing below the code. SqlConnection con = new SqlConnection("Data Source=SERVER;Initial Catalog=MuraliIIT;User ID=sa;Password=rits@1234"); con.Open(); string s = "select count(*) from Test"; SqlCommand com = new SqlCommand(s, con); int count = Convert.ToInt16(com.ExecuteScalar()) + 2; dp1.Text = "dp1.SelectedValue" + count; con.Close(); result: only Display Dropdown value but i need DropDownvalue+increment value
Upendra Pratap Shahi11y ago
ur welcome and thanx for appriciation
Venkata Subbareddy11y ago
Thanks Bro,
But I need some information iam writing below the code.
SqlConnection con = new SqlConnection("Data Source=SERVER;Initial Catalog=MuraliIIT;User ID=sa;Password=rits@1234");
con.Open();
string s = "select count(*) from Test";
SqlCommand com = new SqlCommand(s, con);
int count = Convert.ToInt16(com.ExecuteScalar()) + 2;
dp1.Text = "dp1.SelectedValue" + count;
con.Close();

result:
only Display Dropdown value but i need DropDownvalue+increment value
Venkata Subbareddy11y ago
I write in the Below code id not increment just add please let me know where am doing Wrong... protected void Page_Load(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 Test"; com = new SqlCommand(s, con); con.Open(); count = Convert.ToInt16(com.ExecuteScalar()) + 2; txt1.Text = "E00" + count; con.Close(); }
Venkata Subbareddy11y ago
iam new devloper am fullconfusion please proved Query infomation Pratap ... actually Task is When User choose the Dropdown in location generate The Location+ id please provide source code...
Upendra Pratap Shahi11y ago
create a SP or query and from front end send a dropdown list value for adding location with your query and append tha location with your query which provide to you by me in my previous answer..

This will work for you dear...
Dipankar Biswas11y ago
hi...
When user will select his location then..
but here u must need dropdown option for select user location...
Label14.Text = "dropdownlist.text " + strnewid;

am not sure.. but u can try it...

Thanks..
Venkata Subbareddy11y ago
upendra Pratap , Please provide Sample Code of How to generate userid =loc+automatically increment value..............
Venkata Subbareddy11y ago
i have the Three Locations when user Click the one loctions and Generate loc+ id and user click the secound Locations Generated loc+id...... give c# code
Upendra Pratap Shahi11y ago
check this

http://www.dotnetcurry.com/showarticle.aspx?ID=966
http://www.c-sharpcorner.com/Blogs/6872/
http://www.aspdotnet-suresh.com/2012/04/set-custom-auto-generatedincrement.html

You should add location with your SQL query when user select like:

select 'FHMS' + max(SUBSTRING ( couserid ,5 , 5 ))+1 as nextkey from testtable
Dipankar Biswas11y ago
hi...
check it.. Autogenerate Id

Thanks...
Venkata Subbareddy11y ago
Dipankar , my task requrired C# Source code give me any Logic..
Dipankar Biswas11y ago
Hi..

Check this link.. to help.http://www.aspdotnet-suresh.com/2012/04/set-custom-auto-generatedincrement.html

https://msdn.microsoft.com/en-us/library/ks9f57t0%28v=vs.110%29.aspx
Thanks...