How to generate auto username and user id??????

Rahul Chauhan

I have two problems SQL related and C# related??

Problem No.1

Can anyone plz tell me how to generate username and user id and also how to manage using c# language????

problem No.2

I created a table where I made an auto-increment id column, suppose I start with 100 and increase +1 then I add 4 rows and there are id column entry is 100, 101, 102, 103, Then suppose I deleted 101 and 102 rows entry then again I added 2 rows entry then id column entry become 104, 105, and total entry is 100, 103, 104, & 105 so my question is how can I manage and fill rows on deleted slot or how can I manage and add serial id column values of the table.

if anyone understanding my problems plz tell me the suggestion/answers of both problems.

2 Replies

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

Sachin Singh5y ago
Your second assumption is wrong, never try to fill the slot, it will put your database into an inconsistent state.
however, if you really want to do it, which I consider as wrong then you can follow this query
question 2.
ALTER TABLE [TableName] DROP [id];
ALTER TABLE [TableName] AUTO_INCREMENT = 1;
ALTER TABLE [TableName] ADD [id] int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
question 1.
const string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
int length = 12;
string UserName = new string(Enumerable.Repeat(chars, length).Select(s => s[random.Next(s.Length)]).ToArray());
// now insert this username to db or use the way you want
+1
Md Sarfaraj5y ago
Hey Rahul,
Please check the below link i think it will help you:
https://stackoverflow.com/questions/35779549/generating-username-with-combination-of-characters-c-sharp
+1