I want to genrete a auto number in my project. I used vb.net 2008 and SQl server 2005 as backend?? I want to create a serial no that is like abc/2010/01.In this.

How can i auto genrete a number in vb.net? Taken a simple label and textbox label will auto generate newid. VB.NET DataGridView Cell Serial Number. How can i auto genrete a number in vb.net? Taken a simple label and textbox label will auto generate newid. VB.NET DataGridView Cell Serial Number. It's to add auto number into first. Datatable that is a datasource to the datagridview that has the serial number. Sql server 2005 to vb.net 2005 textbox. Serial Number To A Datagridview in VB.Net. Text/sourcefragment 11/25. Handles DataGridView1.RowsAdded ' Set the number of the new row.

• the abc is same in all the serial no. • the 2010 is used from the running Year.(using date for year) • the 01 is a actual serial no that can be auto genrete. Linksys Spa942 Manual Espanol. But how can i do this.?? And How can i find max number from my serial no.??? How can i maintain it if i delete it then all after delete serial no will place it's place.(there is no break in serial no on delete)??????

Please help me. Amedeo Minghi Discografia Completa De Vicente Montano. You could store the serial numbers in a database table where the third component of the number is the primary key of the table as an identity field. Any time you create a new serial number, you'd insert the current year and the static text into the table. An easy way to do this would be to wrap that logic in a stored procedure which takes no arguments, internally inserts the current year and the text, and returns the entire serial number as a single scalar value.

Something like: INSERT INTO SerialNumbers (Year, Name) VALUES (year(getdate()), 'abc') and: SELECT Name + '/' + CAST(Year AS nvarchar) + '/' + CAST(ID AS nvarchar) FROM SerialNumbers WHERE ID = SCOPE_IDENTITY().

I want to genrete a auto number in my project. I used vb.net 2008 and SQl server 2005 as backend?? I want to create a serial no that is like abc/2010/01.In this. • the abc is same in all the serial no.

• the 2010 is used from the running Year.(using date for year) • the 01 is a actual serial no that can be auto genrete. But how can i do this.?? And How can i find max number from my serial no.??? How can i maintain it if i delete it then all after delete serial no will place it's place.(there is no break in serial no on delete)??????

Please help me. You could store the serial numbers in a database table where the third component of the number is the primary key of the table as an identity field. Any time you create a new serial number, you'd insert the current year and the static text into the table.

An easy way to do this would be to wrap that logic in a stored procedure which takes no arguments, internally inserts the current year and the text, and returns the entire serial number as a single scalar value. Something like: INSERT INTO SerialNumbers (Year, Name) VALUES (year(getdate()), 'abc') and: SELECT Name + '/' + CAST(Year AS nvarchar) + '/' + CAST(ID AS nvarchar) FROM SerialNumbers WHERE ID = SCOPE_IDENTITY().