[Solved] Problem setting datasource programmatically Q2 SP2 2010

[Hilda Kenny]

Hi on the following line I get an error message. (image attached)

bsSearchDebts.DataSource = _DSData

[Richard Slade]

Can you post the whole method please? 

[Hilda Kenny]

Private Sub LoadGrid()
      Dim sSql As String = String.Empty
      Dim sFilter As String = String.Empty
      Dim liRtn As Integer
      Dim DBConn As SqlConnection = DatabaseObject.GetDatabaseConnection()
      Try
          If RadGridViewRequestor IsNot Nothing Then
              bsSearchDebts.DataSource = Nothing
              bsSearchDebts.DataMember = String.Empty
              _DSData.Tables.Clear()
              RadGridViewRequestor.DataSource = bsSearchDebts
              If RadGridViewRequestorDebt IsNot Nothing Then
                  RadGridViewRequestorDebt.DataSource = bsSearchDebts
              End If
              sSql = "SELECT DEBT_ID,DEBT_REFERENCE,FIRST_NAME,SURNAME,ADDRESS_1,ADDRESS_2,ADDRESS_3,ADDRESS_4 FROM TBL_DEBTS " & BuildSql() + " ORDER BY TBL_DEBTS.SURNAME"
              _daDataAdapter = New SqlDataAdapter(sSql, DBConn)
              Try
                  liRtn = _daDataAdapter.Fill(_DSData, "TBL_DEBTS")
              Catch ex As Exception
                  MsgBox(ex.Message)
              End Try
              bsSearchDebts.DataSource = _DSData
              bsSearchDebts.DataMember = "TBL_DEBTS"
              RadGridViewRequestor.DataSource = bsSearchDebts
              If RadGridViewRequestorDebt IsNot Nothing Then
                  RadGridViewRequestorDebt.DataSource = bsSearchDebts
              End If
              CallByName(ParentForm, "Initialise", vbGet)
              Me.RadGridViewRequestor.MasterTemplate.BestFitColumns()
              Me.RadGridViewRequestor.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill
              If RadGridViewRequestorDebt IsNot Nothing Then
                  Me.RadGridViewRequestorDebt.MasterTemplate.BestFitColumns()
                  Me.RadGridViewRequestorDebt.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill
              End If
              If RadGridViewRequestor.Rows.Count > 0 Then Me.RadGridViewRequestor.Rows(0).EnsureVisible()
              CallByName(ParentForm, "SetTotal", vbGet)
          Else
              cbExport.Visible = False
              GetParameters()
              CallByName(ParentForm, "LoadGrid", vbGet)
          End If
      Catch ex As Exception
          MsgBox(ex.Message)
      Finally
          DBConn.Dispose()
          DBConn = Nothing
      End Try
  End Sub

Thanks a lot

[Richard Slade]

Hi,

This really needs to be addressed outside of the Telerik forums as you have a specific binding issues that are not related to the Telerik products, but a quick Google search on your error yielded some interesting results.
This may help
http://www.vbforums.com/showthread.php?t=553638

Richard

[Hilda Kenny]

I appreciate that, but it has only happened after SP2, Maybe there was a windows update or something.

[Richard Slade]

Hi, 

It's a little difficult to tell what is happening but it looks like either your DataSet is going to be empty, or you've lost the data member. 
Richard

[Julian Benkov]

Hi Hilda,

We have not observed similar issues before. Like Richard said, the issue could be related with the DataSet or the internal "TBL_DEBTS" table. Please, check the Rows.Count, Columns.Count properties and try to change the order of setting DataMember and DataSource properties:

bsSearchDebts.DataMember = "TBL_DEBTS"

bsSearchDebts.DataSource = _DSData

Please send us your application and we will try to investigate further. I am looking forward to your reply.

Greetings, Julian Benkov
the Telerik team