Binding TextBox fields to Recordset problem, "Cannot bind to the property"

[mike11d11]

Can anyone Tell me why this code doesnt let me bind a Textbox field to
the Account# column in my SQL table. It says "Cannot bind to the
property or column ACCOUNT# on the DataSource.
Parameter name: dataMember" I've been looking around and some people
have been using the currency manager. If this is a solution could
someone show me how I can add it to my code to make my binding work
correctly. thanks
Public Class Form1
Dim ConnString As String = "Data Source=CBR10602 911;Initial
Catalog=AccuLog ic;Persist Security Info=True;User
ID=AccuLogic;Pa ssword=acculogi c"

Dim ObjConn As New ADODB.Connectio n

Dim ObjRS As New ADODB.Recordset

Dim strRequest As String = "SELECT * FROM dbo.[WorkList]"
Public Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click
With ObjConn

.ConnectionTime out = 30

.CommandTimeout = 30

.Provider = "SQLOLEDB"

.ConnectionStri ng = ConnString

End With

ObjConn.Open()

ObjRS.Open(strR equest, ObjConn,
ADODB.CursorTyp eEnum.adOpenDyn amic, ADODB.LockTypeE num.adLockReadO nly)
ObjRS.MoveFirst ()
Me.TextBox1.Tex t = ObjRS.Fields.It em(0).Value.ToS tring

Me.TextBox1.Dat aBindings.Add(" Text", ObjRS, "ACCOUNT#")

End Sub

End Class

[Ryan S. Thiele]

It might be the crosshatch (#). Try changing the column to [AccountNo] and
see what happens.

--
Thiele Enterprises - The Power Is In Your Hands Now!

--
"mike11d11" <mi*******@yaho o.comwrote in message
news:11******** **************@ i42g2000cwa.goo glegroups.com.. .
Can anyone Tell me why this code doesnt let me bind a Textbox field to
the Account# column in my SQL table. It says "Cannot bind to the
property or column ACCOUNT# on the DataSource.
Parameter name: dataMember" I've been looking around and some people
have been using the currency manager. If this is a solution could
someone show me how I can add it to my code to make my binding work
correctly. thanks
Public Class Form1
Dim ConnString As String = "Data Source=CBR10602 911;Initial
Catalog=AccuLog ic;Persist Security Info=True;User
ID=AccuLogic;Pa ssword=acculogi c"

Dim ObjConn As New ADODB.Connectio n

Dim ObjRS As New ADODB.Recordset

Dim strRequest As String = "SELECT * FROM dbo.[WorkList]"
Public Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click
With ObjConn

.ConnectionTime out = 30

.CommandTimeout = 30

.Provider = "SQLOLEDB"

.ConnectionStri ng = ConnString

End With

ObjConn.Open()

ObjRS.Open(strR equest, ObjConn,
ADODB.CursorTyp eEnum.adOpenDyn amic, ADODB.LockTypeE num.adLockReadO nly)
ObjRS.MoveFirst ()
Me.TextBox1.Tex t = ObjRS.Fields.It em(0).Value.ToS tring

Me.TextBox1.Dat aBindings.Add(" Text", ObjRS, "ACCOUNT#")

End Sub

End Class