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