This code is For auto generate ID
public void generatecode()
{
int r;
{
sconn.Open();
SqlCommand cmd = new SqlCommand("Select max(Voucher_No) from Front_Payment", sconn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
string d = dr[0].ToString();
if (d == "")
{
txtvoucher.Text = "1";
}
else
{
r = Convert.ToInt32(dr[0].ToString());
r = r + 1;
txtvoucher.Text = r.ToString();
}
}
sconn.Close();
}
}