Hi EveryOne

jackat_78 · January 25th, 2005, 10:45 PM

I just want to ask if i can make a binding with my textbox and my combobox using datareader, because i'm looping the fields in my table to display in combobox, i used this command in binding my txtbox, txtbox.databinding.add("text",ds,"table.field"), then if click my combobox i found out that my binding in textbox didn't work. Do i need to put datareader in my dataset? Can u help me to do this.

Life always begin with TRUE or False

Santhi · February 1st, 2005, 01:59 AM

You can assign the value to the textbox by fetching the values from the datareader object and assigning it.

testsubject · December 20th, 2005, 12:46 PM

How would this be done?? As i am using Visual Studio .NEt 2003 and the "Databindings" method is not an option of my text box.

Thanks

planoie · December 20th, 2005, 01:42 PM

myTextBox.Text = dataReader("fieldname")

-Peter

testsubject · December 21st, 2005, 06:35 AM

Hi,

Just going back to binding a datareader to either a textbox or label (in this case a label).

Can anyone see the problem with this code below. I have run the query in SQL and it brings me back a Ward Name but when I load the page I get an error stating that there is No data exists for the row/column. I also manually set the criteria for the query and still get the same error.

Code:

        Dim cmdWardName As New Odbc.OdbcCommand("SELECT WARDNAME, WARDCODE FROM ASSETDDH.WARDS5 WHERE WARDCODE =" & "'" & strWardCode & "'", cnBarwickPas)
        cnBarwickPas.Open()
        Dim drWardName As Odbc.OdbcDataReader
        drWardName = cmdWardName.ExecuteReader()
        lblWardName.Text = drWardName("WARDNAME")
        lblWardName.DataBind()
        drWardName.Close()
        cnBarwickPas.Close()

Any ideas would be gratful.
Thanks

testsubject · December 21st, 2005, 07:02 AM

Just been doing some more testing with this and I am able to use the above datareader to bind it to a drop down list (returns a single value) without a problem.

testsubject · December 21st, 2005, 11:23 AM

But still unable to bind it to a label or text box.

planoie · December 21st, 2005, 02:32 PM

Why are you hung up on databinding it? That may just be overcomplicating things.

-Peter

testsubject · December 21st, 2005, 02:59 PM

How??
Basically i have a number of data readers which fire off SQL commandes to pull back a single value which i want to bind to a label/textbox.

rodmcleay · December 21st, 2005, 09:07 PM

With a reader i think you would call the next record or something like that.

Something like this maybe:
If (drWardName.Read) Then
lblWardName.DataTextField = drWardName("WARDNAME")
lblWardName.DataBind()
End If

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================