0 Replies - 415 Views - Last Post: 18 September 2012 - 03:01 AM Rate Topic: -----

#1 Codaholic  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 22
  • Joined: 18-September 12

Cannot bind to the property or column pati on the DataSource.

Posted 18 September 2012 - 03:01 AM

Hi guys, am trying to string manipulate the patientID returned after the code below is executed but i keep getting the error: Cannot bind to the property or column pati on the DataSource.
Parameter name: dataMember, on the second last line i.e mdiChildTBScreeningFrm.txtPID1.DataBindings.Add("Text", objDataView, Mid("patientID", 1, 4))

Private Sub BindHeaderControls()
        sqlString = "SELECT COUNT (*) AS numRows FROM tblEnrollment WHERE patientID='" & patientID & "'"
        Call ExecuteProcedures1()

        If queryResult > 0 Then
            Call OpenConnectionToDb()
            Dim objDataAdapter As New OleDbDataAdapter("SELECT * FROM tblEnrollment WHERE patientID='" & patientID & "'", objConnection)
            Dim objDataSet As DataSet
            Dim objDataView As DataView

            objDataSet = New DataSet
            objDataAdapter.Fill(objDataSet, "tblEnrollment")
            objDataView = New DataView(objDataSet.Tables("tblEnrollment"))

            mdiChildTBScreeningFrm.datePickerTodaysDate.DataBindings.Add("Text", objDataView, "todaysDate")
            mdiChildTBScreeningFrm.datePickerTodaysDate.Enabled = False
            mdiChildTBScreeningFrm.txtPID1.DataBindings.Add("Text", objDataView, Mid("patientID", 1, 4))
            Call CloseConnectionToDb()
        Else
        End If

    End Sub



Is This A Good Question/Topic? 0
  • +

Page 1 of 1