Re: Newbie Question

From: Cor Ligthert (notmyfirstname_at_planet.nl)
Date: 11/17/04 

Date: Wed, 17 Nov 2004 18:53:34 +0100

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/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataSqlClientSqlCommandClassExecuteNonQueryTopic.asp

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

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlconnectionclasstopic.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

"Peter Newman" <PeterNewman@discussions.microsoft.com>

> 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 ?