[andreasberglind]

Could someone tell me how to retreive a single row from a SQL database and display it on a .aspx page? This component/function is only going to display a name, so it´s probably very simple, i just need to find out wich way to go.

Could someone point me in the right direction?

Thanks!

[thuenb]

Basically you create a Sql statement that gives you only the column of data that you want... Without coding the whole thing... Something like this..

Code:

imports system.data
imports system.data.sqlclient


Dim cnn As New SqlConnection("User Id=MyUserID;Password=MyPassword;Initial Catalog=DBName;Server=255.255.255.255")

'Modify the SQL string to match your criteria
Dim cmd As New SqlCommand("Select Name From TableName where Id = 0", cnn) 

label.Text = cmd.ExecuteScalar

'Don't forget to clean up your connection and cmd objects by setting them to nothing

hope this helps....