hi, can anyone tell me what this section of code does, i got it from a site but the guy hasnt commented it well, by the way i am using a sql data provider, and the code here uses oledb so any ideas how i can do this in sql data provider. many thanks in advance

command.Parameters.Add("username ", Data.OleDb.OleDbType.Variant)

command.Parameters.Add("password", Data.OleDb.OleDbType.Variant)

command.Parameters("username").Value = TextBox1.Text

command.Parameters("password").Value = TextBox2.Text

You can think of a command as a bridge between your application and a Connection object. A command object can hold a SQL statement, or stored procedure name and has a parameter collection. Parameters can be send off to the database, in case of a Stored Procedure or a parameterized SQL statement.

In this case, two parameters are added to the command's param collection. To make this Sql parmas, replace OleDb with Sql.

Look in the MSDN for loads and loads of more examples of this:

http://msdn.microsoft.com/library/en...classtopic.asp
http://msdn.microsoft.com/library/en...classtopic.asp
http://msdn.microsoft.com/library/en...ClassTopic.asp
Hope this helps,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: The Dark Of The Matinee by Franz Ferdinand (Track 4 from the album: Franz Ferdinand) What's This?

hi i have just replaced the oledb bits to sql and i get an error, under "data.sql" it says sql is not a memeber of data.
the code is show below what i have done, many thanks in advance

             command.Parameters.Add("username ", Data.sql.sqlType.Variant)

            command.Parameters.Add("password ", Data.sql.sqlType.Variant)

            command.Parameters("username").Value = TextBox1.Text

            command.Parameters("password").Value = TextBox2.Text

If you follow the links I posted, you'll see that the Sql stuff lives in the System.Data.SqlClient namespace.

But IMO, this is never going to work right. Apparently, you're missing a couple of (if not all) important concepts related to .NET. The way I see it, you cannot really learn a new technology by asking questions in a forum. You should do so by reading books and web sites. Of course forums can aid in the learning process, but they cannot teach you everything. If I were you, I'd get a copy of this book:
http://www.wrox.com/books/0764556584.shtml

This books deals with basic VB .NET concepts, including accessing databases etc.

Right now, you try to learn driving on the Monaco circuit, while the parking lot next to your local super market is probably a much better place to start ;)
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Lately by Skunk Anansie (Track 6 from the album: Post Orgasmic Chill) What's This?