Rahul Chauhan

Rahul Chauhan

  • 1.2k
  • 499
  • 30.7k

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

Jul 6 2021 6:53 AM

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.


Answers (2)