Resultat af Sql string i label

Fx. sådan her:

Dim myConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\my.mdb")
Dim myQuery As String = "Select Top1 Name From MyTable"
Dim myOleDbCommand As New OleDbCommand(myQuery,myConn)
myConn.Open()
Dim myReader As OleDbDataReader = myOleDbCommand.ExecuteReader()
Try
    While myReader.Read()
          LeftMenuTitles.Text = myReader.GetValue("Name")
          Exit While
    End While
Finally
    myReader.Close()
    myConn.Close()
End Try

//>Rune

Hov, det skulle jo så være til en label...:_

Dim myConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\my.mdb")
Dim myQuery As String = "Select Top1 Name From MyTable"
Dim myOleDbCommand As New OleDbCommand(myQuery,myConn)
myConn.Open()
Dim myReader As OleDbDataReader = myOleDbCommand.ExecuteReader()
Try
    While myReader.Read()
          lblResultat.Text = myReader.GetValue("Name")
          Exit While
    End While
Finally
    myReader.Close()
    myConn.Close()
End Try

//>Rune

Hvis dit resultat kun består af en enkel værdi kan du bruge ExecuteScalar() istedet. Så slippet du for at loope igennem en datareader.

Hej Rune!

Tak for et hurtigt svar, det virker bare så godt.

cuac

Anytime ;o)
Thx 4 Poinz

//>Rune