.Net

Pankaj Kumar


EId
Manager
EName
Email
Mobile
Department

Hey how to increment Eid after E10

by selected manager and How to increment E001,E010,E011 like

5 Replies

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

Pankaj Kumar12y ago
Thanks vulpes
Vulpes12y ago
One thing that has just occurred to me is that, after saving E10 back to the database, you will then have a problem with the query as it stands because E10 will order before E2 to E9. So, the query will always return E9.

To avoid this problem, change the query to the following:

string query = "SELECT TOP(1) EId FROM emps ORDER BY CAST(SUBSTRING (EId, 2, LEN(EId) - 1) AS INT) DESC";
Vulpes12y ago
Well, I can't see any obvious reason why that code shouldn't increment the EId value.

So are you saying that E9 is being read from the database but, even though the code is getting executed, it still displays E9 rather than E10?
Pankaj Kumar12y ago

Main Page
Photo
Document
Bill

Admin Admin
Module Add Delete Update View
Photo
Document
Bill Status

User Login
Module Add Delete Update View
Photo
Document
Bill Status

Main Page Both are see Admin and User but All file control by Admin
just Like 1=>Photo admin allow all permission and check Button Enable all like add,Delete,update,view
2=>But Document admin checked only add User Only add Document not Allow Delete,update ,view.
3=>But Bill section Admin only check View User Only View bill Not Add,Delete,updated.

Pls tail me how to write code logic
Vulpes12y ago
Try this:

using System;

class Program
{
static void Main()
{
// increment a single Id
string nextId = GetNextId("E10");
Console.WriteLine(nextId);
Console.WriteLine();

// now get a sequence of Ids
nextId = "E001"; // first Id
Console.WriteLine(nextId);

for(int i = 2; i <= 10; i++)
{
nextId = GetNextId(nextId);
Console.WriteLine(nextId);
}

Console.ReadKey();
}

static string GetNextId(string lastId)
{
int count = lastId.Length;

for(int i = 0; i < lastId.Length; i++)
{
if (Char.IsDigit(lastId[i]))
{
count = i;
break;
}
}

string letters = "";
if (count > 0) letters = lastId.Substring(0, count);

string digits = "";
if (count < lastId.Length) digits = lastId.Substring(count);

if (digits == "") return letters + "1";
int number;
int.TryParse(digits, out number);
number++;
return letters + number.ToString("D" + digits.Length);
}
}

The output should be:

E11

E001
E002
E003
E004
E005
E006
E007
E008
E009
E010

Admin Admin
Module	Add Delete	Update View
Photo
Document
Bill Status

User Login
Module	Add Delete	Update View
Photo
Document
Bill Status

.Net

EId Manager A B C EName Email Mobile Department Hey how to increment Eid after E10

EId
Manager
EName
Email
Mobile
Department

Hey how to increment Eid after E10