Getting next ID number from database

Question

I want to display the next ID Identity seed  number thats in the database in a label on my form Is there a way I can do something on page load to get maxCareID  1 to display in label2text when the page loads I want the next number to be displayed in this label MRID ltaspLabel ID34Label234 runat34server34 Text3434gtltaspLabelgt Thanks

Mudassar · Accepted Answer

1 I think you need to first create a table Seed with a single column say SeedValue Integer And set its initial value 02 Then you need to fire the following SPcreate procedure GetSeedasbeginupdate Seedset SeedValue  SeedValue  1select SeedValue from Seedend 3 In code do as following  Dim Conn As New SqlConnection34Data Sourcecmssolutionsdb9373013hostedresourcecom Initial Catalogcmssolutions User IDCMSSolutions PasswordCMSMedical134        Dim Comm1 As New SqlCommand34GetSeedValue34 Conn        Comm1CommandType  CommandTypeStoredProcedure        ConnOpen            Label2Text  Comm1ExecuteScalarToString        ConnClose

Mudassar · Answer

Use this SPalter procedure GetSeedasbeginupdate WeightAssessmentset weightid weightid 1 select weightid from WeightAssessmentend

Getting next ID number from database

Company

Explore

Follow us

Contact Us