gathering db fields in var

[amtrac24]

Hi guys,

I am using vb.net. I was wondering how to do something that I have found a work around for. Basically lets say I am creating a log-in page. When the user clicks log in I run sql to find the user name and pw. I then have 2 hidden text fields that are linked to the database fields. Then i say if txtUsername.text=txtHiddentext.text and txtpw.text=txthiddenpw.text then show main page.

I was basically wondering how do i grab a database field and put it into a variable instead of hiding a text box field? i know there is a way to do it but not to sure how. Thanks for your help guys.

[Creosote]

What do you mean put them into a variable? Theres not much to it:

Dim UserName As String
Dim Password As String
UserName = YourDataRow.Item("UserName")
Password = YourDataRow.Item("Password")


or you could use sessions variables:

Session("UserName")=

[amtrac24]

sorry for anther stupid question. How do you configure the datarow? I dont use or dont know how to use a datarow when connecting to a db. Thanks for your help.

[amtrac24]

i think i got it.

OleDbDataAdapter1.SelectCommand.CommandText = _
"SELECT user_name, user_password " & _
"FROM users where user_name='" & username & "';"

DataSet11.Clear()
OleDbDataAdapter1.Fill(DataSet11)

Dim i As String

i = DataSet11.Tables("users").Rows(i).Item("user_name" )
MsgBox(i)

Thanks for your help. It works

[Creosote]

That's basically the decision you have to make. There are so many ways to get data. If you are just looking to get the one row, then I wouldn't go with a DataSet. Here is the breakdown:

1. If you need to maintain multiple tables of data, use a DataSet
2. If you need to maintain just one table, and are interested in more than one row, use a DataTable.
3. If you don't need to maintain any data and dont need to save the actual data (which looks like what you are doing), use a DataReader.
4. If you just need ONE column's value, use just the one column in your SELECT statement, and use the .ExecuteScalar() method of your command.

Alternatively, if you need just one row of data, but many columns, use output parameters if your database supports stored procedures. This way, you just execute the command and check its parameters.