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.