updating code

[jmcilhinney]

When you get rid of all the late binding the method is rather simple. It takes a DataSet and a String containing an SQL query, then populates a DataTable in the DataSet and returns a new DataView of that table. I'd suggest you write a method from scratch that does that.

[Geek-O]

This is what i have come up with. It shows no errors in VS but i have not tested it in tha actual ap yet. does this look correct?

Public Function bindthissql_SQL(ByVal fds As Object, ByVal fsql As Object) As Object
            Dim MyAdapter As New SqlDataAdapter(StringType.FromObject(fsql), Me.dbconn3)
            MyAdapter.Fill(DirectCast(fds, DataSet), "Thedata")
            Return New DataView(DirectCast(LateBinding.LateGet(fds, Nothing, "Tables", New Object() { "Thedata" }, Nothing, Nothing), DataTable))
        End Function