Loading

How to delete bill number auto Increment in windows APP. C#

How to delete bill number auto Increment in windows APP. C#

Jyoti Jodha

Jyoti Jodha

8y1kWindows Forms

How to delete bill number auto Increment

Suppose I Have 50 Bill Total and I delete bill number 10 to 25. Now when creating new bill number

Bill Number 10 and then complete 25 bills

After create new bill 51 number

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

private int billno(string p)

{

Int32 Billno = 0;

//s = Billno;

cmd = new SqlCommand(p, con);

int k;

con.Open();

if (txtbill.Text != "")

{

Billno = Convert.ToInt32(txtbill.Text);

k = Billno;

s = k;

k = (Int32)cmd.ExecuteScalar();

con.Close();

return Billno;

}

else

{

Billno = s;

Billno = (Int32)cmd.ExecuteScalar();

con.Close();

return Billno;

}

}

2 Replies

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

Amit Gupta8y ago
Hey

As Ramesh has pointed out, if the billno is an identity column then yes, it is not possible to reset the identity unless you truncate the table/ or having unique (in short too complex and not recommend)

If its not then, you need ro find out the missing billno from your table like
Select Top 1 billno + 1 from billform T1
where not exists
   (select * from billform T2 where T2.billno = T1.billno + 1)
order by billno asc
I have not tested the above query but you can have an idea and search for web for finding missing numbers a bit.

Moreover, if it is an billing software then its highly recommend that you DON'T DO THAT, there can be mismatch in the billing procedure that might occur in future. Ask you client that this approach is not good. If the bill has been deleted, you cannot create the bill on the same billno.
0
Ramesh Palanivel8y ago
Hi Jyothi,

For your scenario, that is not that much possible. Its little bit complex. The Identity always will count the value from last seed.

For your scenario, You have to reset the seeds.

Check in inernet how to reset the Seeds.
0