private void lbtnnew_Click(object sender, EventArgs e)
{
loanform lf = new loanform();
lf.Show();
con.Open();
SqlCommand cd = new SqlCommand("SELECT TOP 1 RIGHT(AccountNo,1)+2 From loanform order by 1 desc", con);
SqlDataAdapter da = new SqlDataAdapter(cd);
object VALUE = da.SelectCommand.ExecuteScalar();
VALUE = "accno:" + VALUE;
accno.Text = VALUE.ToString();
}
private void toolsMenu_Click(object sender, EventArgs e)
{
loanform lf = new loanform();
lf.Show();
}