How to generate bill number show in Textbox from database in c#

what change in this code to show billno in textbox

private int billno(string p)
{
Int32 Billno = 0;
cmd = new SqlCommand(p, con);
con.Open();
Billno = (Int32)cmd.ExecuteScalar();
con.Close();
return Billno;
// int billno = 0;
//billno = billno + 1;
//txt_billno.Text = billno.ToString(p);
}

int Billno = billno("Select ISNULL(Max(Billno+1),1) From MainBillForm");

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted answer
hi
to show billno in text box

yo have to assign billno into text box as shown below

int Billno = billno("Select ISNULL(Max(Billno+1),1) From MainBillForm");
txtbillno.Text=Billno.ToString();

txtbillno is your textbox name
Jyoti Jodha9y ago
This Code is working
private int billno(string p)
{
Int32 Billno = 0;
cmd = new SqlCommand(p, con);
con.Open();
Billno = (Int32)cmd.ExecuteScalar();
con.Close();
return Billno;
// int billno = 0;
//billno = billno + 1;
//txt_billno.Text = billno.ToString(p);
}

int Billno = billno("Select ISNULL(Max(Billno+1),1) From MainBillForm");

But i am want to show bill no in textbox.....??
what change in this code to show Bill No in Textbox....??
Amresh S9y ago
Hi Jyothi,

Try this:
int num = Convert.ToInt32(cmd.ExecuteScalar().ToString());
You should use a null check, if the query returns null value.

Regards,
Amresh S.