How to Generate Based on Location AutoGenerate Number using

Venkata Subbareddy

Hi Every one,

Today Iam develop one module here i faced Some Many Problems Please solve them..

Actully when user select The Location in dropdownlist based Location First 3 letters + auto increment Id Will Be Display On TextBox ..... Please Give Suggesttions in the Below iam writeing Logic Let me know Any modifications....

protected void dpCity_SelectedIndexChanged(object sender, EventArgs e)

{

AutoNumber();

}

public void AutoNumber()

{

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

TxtUserid.Text = dpCity.SelectedItem.Text + count;

con.Close();

}

2 Replies

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

Nanhe Siddique11y ago
just change in
public void AutoNumber()
{
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()) + 1;
TxtUserid.Text = dpCity.SelectedItem.Text.ToString().Substring(1,3) + count;
con.Close();
}
it may help you
Dipankar Biswas11y ago
Hi

Check this link to help...Increment AlphaNumeric

thanks...