Masters help me see how to correct this error

weirui1231

I used it first: Dim binds As BindingSource = New BindingSource
        Dim dt As DataTable = New DataTable
        Dim da As Odbc.OdbcDataAdapter
        Dim Conn As New Odbc.OdbcConnection
        Conn = Me.comm.DBopen ()
        da = New Odbc.OdbcDataAdapter (sSelectCmd, Conn)
        da.Fill (dt)
        binds.DataSource = dt
        Me.DgViewReportCode.DataSource = binds
        Me.BindingNavReportCode.BindingSource = bind
************************************************** *******
And then used it in another process
           Dim dt1 As DataTable = New DataTable ()
             dt1 = Me.DgViewReportCode.DataSource '' 'Error reported here
                    IsPaste = False
                    dt1.AcceptChanges ()
 The error is: "Cannot convert System.Windows.Forms.BindingSource type to System.Data.DataTable type"

Why is it reporting such a mistake ... how to change it ????
(If I block the above *, the following is correct, but I cannot block any code above)

nijiaoshaa

When you use the DataAdapter object to fill it, you should use the data set instead of the table. Modify it to the following:
Dim binds As BindingSource = New BindingSource
        Dim ds As DataTable = New DataSet
        Dim da As Odbc.OdbcDataAdapter
        Dim Conn As New Odbc.OdbcConnection
        Conn = Me.comm.DBopen()
        da = New Odbc.OdbcDataAdapter(sSelectCmd, Conn)
        da.Fill(ds)
        binds.DataSource = ds.Tables(0)
        Me.DgViewReportCode.DataSource = binds
        Me.BindingNavReportCode.BindingSource = bind

Another process uses:
           Dim dt1 As DataTable = New DataTable()
             dt1 = Me.DgViewReportCode.DataSource
                    IsPaste = False
                    dt1.AcceptChanges()

weirui1231

Thanks to the brother upstairs for answering...

  But if you change this way, you still get the same error
   dt1 = Me.DgViewReportCode.DataSource

   The type of dt1 is "System.Data.DataTable",
  The type of Me.DgViewReportCode.DataSource is "System.Windows.Forms.BindingSource"

  These two don't match...the conversion can't come.........


  What should I change...?