vb.net implementation to add a user for sqlserver and give the user a certain full line

wcckuand

As the title
Please help me a lot, waiting for urgent use, thank you in advance

pocketpc

This is the sql problem. Not a .net problem. Let me write it for you.

pocketpc

Create a login if there is no login
The first parameter is the name of the login, the second is the password, and the third is the default database.
EXEC sp_addlogin 'abcd', '123', 'northwind'
Then create user
The first parameter is the name of the login, the second is the username, and the third is the groupname, which can be omitted.
EXEC sp_adduser 'abcd', 'Victoria'