How to Generate the automatic userid based on Location

Question

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...

Upendra Pratap Shahi · 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 Sreelakshmi · Answer

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 Subbareddy · Answer

dp1.Text = dp1.SelectedValue + count.ToString(); corrct or wrong???

Upendra Pratap Shahi · Answer

kindly convert dropdown value in integer type then add count if you have want to dropdown value with addition of incremented value.

Venkata Subbareddy · Answer

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 Shahi · Answer

ur welcome and thanx for appriciation

Venkata Subbareddy · Answer

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 Subbareddy · Answer

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 Subbareddy · Answer

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 Shahi · Answer

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 Biswas · Answer

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 Subbareddy · Answer

upendra Pratap  Please provide Sample Code of How to generate userid =loc+automatically increment value..............

Venkata Subbareddy · Answer

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 Shahi · Answer

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 Biswas · Answer

hi... check it.. Autogenerate Id Thanks...

Venkata Subbareddy · Answer

Dipankar  my task requrired C# Source code give me any Logic..

Dipankar Biswas · Answer

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...