DataBinding a textbox

[ninelgorb]

I know how to bind data to a dropdown, but how can I bind to a textbox when it doesn't have the datasource property?

This is what I havae so far:

Private Sub ddlEmployee_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlEmployee.SelectedIndexChanged

        sAgentId = ddlEmployee.SelectedValue
        If sAgentId = "0" Then
            lblResult.Text = "Please Select an Employee"
        Else
            Call PopulateDDLs(sAgentId)
        End If
End Sub

Sub PopulateDDLs(ByVal sAgentId As String)
sSQLPayRollId = " SELECT iPayrollid FROM dbo.EmEmployee WHERE sAgentid= "" & ddlEmployee.SelectedValue & """
        sConn = System.Configuration.ConfigurationSettings.AppSettings.Item("connString")
        oConn = New SqlConnection(sConn)
        oConn.Open()
        oComm = New SqlCommand(sSQLReport, oConn)
        oReader = oComm.ExecuteReader()
       ????--- txtPayId.datasource = oReader ---??????
End Sub

Based on user's selection from dropdown I need to populate the textbox.

Any help would be greatly appreciated.
Thanks,
Ninel

 

[jbenson001]

A textbox has a databindings property which you have to set in the properties window.

 

[ninelgorb]

When I use this property within the code I get a squiggly line underneath and it says 'DataBindings is not a member of 'System.Web.UI.WebControls.Textbox'.
Does this mean the only way I can use this property is within the property window?

 

[jbenson001]

As far as I know, you have to use the properties window.

 

[ninelgorb]

I am looking at the property window and I don't understand how to use the databindings property.
Can you please help me out?

Thanks,
Ninel

 

[jbenson001]

Click on the elipsis.. the "..." button in box next to databindings. A popup window comes up with bindabale properties. Text is chooen by default. Then in the right pane, drill down to the object(column) you want to bind to.

 

[ninelgorb]

On the right side I only see simple binding or custm binding radio buttons. Inside the simple binding I see unbound and page. That's it.

Am I missing something?

 

[jbenson001]

You should see any datasets, dataviews etc. that have been created on the design portion of your page.