Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Error in Autogenerating empcode in asp.net
ancy chacko
Feb 18 2015 1:03 AM
535
Reply
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();
}
}
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
High CPU Utilization in Random Pin Generation
How To Sum Value Of Gridview Column In C#.net (Win App)