1. I think you need to first create a table Seed with a single column say SeedValue Integer. And set its initial value 0
2. Then you need to fire the following SP.
create procedure GetSeed
as
begin
update Seed
set SeedValue = SeedValue + 1
select SeedValue from Seed
end
3. In code do as following
Dim Conn As New SqlConnection("Data Source=cmssolutions.db.9373013.hostedresource.com; Initial Catalog=cmssolutions; User ID=CMSSolutions; Password=CMSMedical1")
Dim Comm1 As New SqlCommand("GetSeedValue", Conn)
Comm1.CommandType = CommandType.StoredProcedure
Conn.Open()
Label2.Text = Comm1.ExecuteScalar().ToString()
Conn.Close()