Invalid column name 'txt_billno'..in windows application c#
private int txt_billno(string p)
{
Int32 txt_billno = 0;
cmd = new SqlCommand(p, con);
con.Open();
txt_billno = (Int32)cmd.ExecuteScalar();
con.Close();
return txt_billno;
}
private void MainBillfrm_Load(object sender, EventArgs e)
{
int Billno = txt_billno("Select ISNULL(Max(txt_billno+1),1) From MainBillForm");
}
{
Int32 txt_billno = 0;
cmd = new SqlCommand(p, con);
con.Open();
txt_billno = (Int32)cmd.ExecuteScalar();
con.Close();
return txt_billno;
}
private void MainBillfrm_Load(object sender, EventArgs e)
{
int Billno = txt_billno("Select ISNULL(Max(txt_billno+1),1) From MainBillForm");
}

Rafnas T PPosted Jun 13, 2017, 2:35 AM
Jyoti JodhaPosted Jun 13, 2017, 4:42 AM
Rajkiran SwainPosted Jun 13, 2017, 3:17 AM
Jyoti JodhaPosted Jun 13, 2017, 2:32 AM
Rafnas T PPosted Jun 13, 2017, 2:28 AM