My question is regarding Asp.net C # and Sql server 2008

Mohammed Khadir

10y970SQL

i am working on windows application in database i have a table which has Invoice number which is a primary key and keep increments by one number or so, when ever a new record is added, so what i want is,

i have a form which requires invoice number to be loaded in that form when page load, and when the record is saved that invoice number to be shown in a message box,

Sir please help me to achieve this,

It will be great-full Sir.

4 Replies

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

Mohammed Khadir10y ago
Thanks for every one
I got Solution to this by below code with all your help
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = " Select MAX(ColumnName)+ 1 FROM DatabaseName.dbo.TableName";
textbox1.Text = "" + cmd.ExecuteScalar().ToString();
con.Close();
0
Hussain Patel10y ago
I would suggest - on the page load.. get the last invoice number from the table andin thepage increment by one and display itnext to the invoice label onUI. so when the record is save you have the invoice number that is unique and you can save in and insert a record in the database and show the same number in message box once the record is saved..
Hope this helps.
+1
Vinay Singh10y ago
Use Storedprocedure in SP use below query as
insert into InvoiceTable(item,name,qty) value(@item,@name,@qty)
select @@identity as InvoiceNo
So don't use ExecuteQuery();
use dataTable to execute the above SP.
+1
Midhun Tp10y ago
Hi,
According to your table structure, you will get invoice number only when a new row is inserted in to table. So in order for you to show that invoice number in form before saving data, you have to insert a new empty row whenever someone views a form and retrieve that invoice number and display it in form. Now when users submits form, you have to update the row with the invoice number that you showed in the form.
+1