how to generate sequence using vb.net express

[Ralph Lauren]

I am using VB.net & trying to build a application for Office use & this Application is build for office information. I have created tables in it where every table has its on columns And are given the the primary key to each column. Now how can i create sequence in it....???

[Zecho]

Here is an example with reference to generate sequence in Letters. This may help you alot....!

           char Letter = Char.Parse("A");
            int Count = 26;
            for (int i = 0; i < Count; i++)
            {
                    Response.Write(Letter);
                    Letter++;
            }
            Letter = Char.Parse("A");
            for (int i = 0; i < Count; i++)
            {
                Response.Write("A"+Letter);
                Letter++;
            }

[kelfro]

Here another example working with SQL Server with C#

private void Test()
{
SequentialGuid = new SequentialGuid(Guid.Empty);
SequentialGuid++;
}


and C# code that increments GUIDs sequentially:

public class SequentialGuid
{
Guid _CurrentGuid;
public Guid CurrentGuid
{
get { return _CurrentGuid; }
}

public SequentialGuid()
{
_CurrentGuid = Guid.NewGuid();
}

public SequentialGuid(Guid previousGuid)
{
_CurrentGuid = previousGuid;
}

public static SequentialGuid operator ++(SequentialGuid sequentialGuid)
{
byte[] bytes = sequentialGuid._CurrentGuid.ToByteArray();
for (int mapIndex = 0; mapIndex < 16; mapIndex++)
{
int bytesIndex = SqlOrderMap[mapIndex];
bytes[bytesIndex]++;
if (bytes[bytesIndex] != 0)
{
break;
}
}
sequentialGuid._CurrentGuid = new Guid(bytes);
return sequentialGuid;
}

private static int[] _SqlOrderMap = null;
private static int[] SqlOrderMap
{
get
{
if (_SqlOrderMap == null)
{
_SqlOrderMap = new int[16] { 3, 2, 1, 0, 5, 4, 7, 6, 9, 8, 15, 14, 13, 12, 11, 10 };
}
return _SqlOrderMap;
}
}
}