Newbie Question

[Guest]

Im just starting to look at vb.net and am trying to get my head around making
a connection to a SQL server.

Basicly, i have a form with two text boxes and a command button. when the
command button is clicked, i want to check in the SQL table if that 'user
name' ( text box 1) and password ( text box 2) exist.

Can anybody explain in simple steps how to work the sql query ?

 

[Cor Ligthert]

Peter,

This is not the normal purpose, so have a look at AdoNet on MSDN.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbpj01/html/gs0501.asp

However in your sample it is probably better to take this command
http://msdn.microsoft.com/library/d...ClientSqlCommandClassExecuteNonQueryTopic.asp

The only thing not written here was I thought how to set a connection

http://msdn.microsoft.com/library/d...ystemdatasqlclientsqlconnectionclasstopic.asp

This is for SQL server that is SQLclient.SQLxxxxx for Access or other it can
be OleDB what is OleDb.OleDb, than almost all with exeption from the
parameters is as far as I know the same.

I hope this helps?

Cor