Returning column data...

[skinrock]

Okay, I'm using VB.NET and SQL. Now, the accessing and updating of the database works fine. Now I'm trying to retrieve the data. So far I have:

sql_command.CommandText = "SELECT uid FROM userlist WHERE uname = ' " & txtUName.Text & " ' AND pword = ' " & txtPWord.Text & " '"
sql_command.ExecuteNonQuery()

What would I need to do to save the return value? I tried saying:

Dim result As Integer (and also As String)
result = sql_command.ExecuteNonQuery()

but all I ever get is -1, even when I say:

sql_command.CommandText = "SELECT uid FROM userlist"

So how do I save the value from a SELECT statement? Thanks!

 

[skinrock]

Also, is there a different route you guys would use? Like using a dataset or something? I'm still fairly new to doing databases and VB.net, and the only thing I have available is this MSDE database, so I wasn't sure what other way I could access it other than through SQL queries.

 

[chrissie1]

the value you get in result is wether or not the sql-statement got executed or not. -1 means that it executed just fine. if you want to get that data you will have to put it in a datatable.

dim dt as new datatable
dim ad as new sqldataadapter
dim sql_command as new sqlcommand

'Connect sql_command too connection
sql_command.CommandText = "SELECT uid FROM userlist WHERE uname = ' " & txtUName.Text & " ' AND pword = ' " & txtPWord.Text & " '"
ad.selectcommand = sql_command
ad.fill(dt)
firstresult = dt.rows(0).item("uid")

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting