Hello there:D,
I just want to create a simple login that reads in a user name and password and check them against a table in MS SQL Server but using ADO.NET. The examples in the book seem to use access. I only want something basic that will display another form if the password is right and if not display an error message. Im only a beginner so any help is appreciated;)

Hi there,

If the examples are in Access, all you need to do is replace OleDb with SQL. So, for example:

Dim MyConnection As New OleDbConnection

becomes

Dim MyConnection As New SqlConnection

Obviously, you'll also need to change the connection string so it points to a SQL Server, not to an Access database file.
To search for the user in the database, you can use a SqlCommand that holds the SQL statement (something like SELECT FirstName, LastName FROM Users). Take a look here for details about this object.
To pass the username and password, you can use Parameter objects which you attach to the Command object, as described here.

If you search Google for SqlConnection, SqlCommand, SqlAdapter etc, you'll find loads of examples. Also, the examples in the ASP.NET SDK contain quite a lot of SQL examples.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks much appreciated!!!! Have working just dandy now:) Dont suspose you know anything about web services??? in the book it speaks of a XML Web Service Proxy Generator, apparently it is under tools but i cannot find it i know i can generate a proxy through the command line but dont have a clue any suggestions??