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

Answer 1

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();

}

 

Answer 2

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

 

Answer 3

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

Answer 4

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

Answer 5

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

Answer 6

ur welcome and thanx for appriciation

Answer 7

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

Answer 8

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(); }

Answer 9

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

Answer 10

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

 

 

 

 

Answer 11

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

 

Answer 12

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

Answer 13

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

Answer 14

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

Answer 15

hi...

check it.. Autogenerate Id

 

Thanks... 

Answer 16

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

Answer 17

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