i want autogenerating empcode.
k001..k002,k003
error:::
Input string was not in a correct format.
cn.open();
int r;
string str = "select MAX(empcode) from tbl_organization1";
MySqlCommand cmd = new MySqlCommand(str, cn);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
string a = dr[0].ToString();
if (a == "")
{
lblempcode.Text = "K" + 001;
}
else
{
string v = a.TrimStart('K');
r = Convert.ToInt32(v);
r = r + 1;
string strtt = "K" + string.Format("{0:000}",r); ;
lblempcode.Text = strtt.ToString();
// = strtt + 1;
}
cn.Close();
}
}