Databinding to a label

Dwizz · August 1st, 2005, 11:32 AM

Hey all,
I'm trying to databind to a label, but I keep getting compiler error, my code is below, Can someone please help.

Code:

Label38.Text = "Price"
Label38.Datasource = serverprice(Label2.text)
Label38.DataBind()

THE FUNCTION serverprice is as follows

Dim queryString As String = "SELECT [System].[Price] FROM [System] WHERE ([System].[Server_ID] = @Server_ID)"
        Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
        dbCommand.CommandText = queryString
        dbCommand.Connection = dbConnection

        Dim dbParam_server_ID As System.Data.IDataParameter = New System.Data.OleDb.OleDbParameter
        dbParam_server_ID.ParameterName = "@Server_ID"
        dbParam_server_ID.Value = server_ID
        dbParam_server_ID.DbType = System.Data.DbType.String
        dbCommand.Parameters.Add(dbParam_server_ID)

        Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter
        dataAdapter.SelectCommand = dbCommand
        Dim dataSet As System.Data.DataSet = New System.Data.DataSet
        dataAdapter.Fill(dataSet)

What I'm trying to do is get the price for the server from the DB and display it in the label
As always all help is appreciated

Imar · August 1st, 2005, 01:20 PM

Hi there,

A Label doesn't have a DataSource. Instead, you can bind its Text property in code behind. Something like this will work:

Label38.Text = serverprice(Label2.text)

Where serverprice returns a *string*, like this:

Return myDataSet.Tables(0).Rows(0)("YourColumn").ToString ()

This code returns the column called YourColumn from the first row of the first table in the dataset.

If you only need a single string returned from serverprice, then you could use the quicker DataReader or a stored procedure with out put parameters.

HtH,

Imar

P.S. Nice and descriptive variable names.... ;)

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Tarantula by This Mortal Coil (Track 6 from the album: Filigree and Shadow) What's This?

Dwizz · August 2nd, 2005, 03:09 AM

Thanks Imar,
I'll give that a try I'm not sure how to code it, but how would I implement the;

Return myDataSet.Tables(0).Rows(0)("Price").ToString()

into my code??

Label38 = Return myDataSet.Tables(0).Rows(0)("Price").ToString()??? ?

If you could please assist me, many thanks.

D

Imar · August 14th, 2005, 04:19 AM

Oops, I missed your reply in this thread. Is this still an issue for you??

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.