Datagrid fill from query

Hi all

I am trying to fill the datagrid from the query
I have textboxes, comboboxes and checkboxes
and i create a query according to those fields

How can I display them on the datagrid?

"Select mName As " & NameLang & ", mSurnamae As " & SurnameLang & "," etc...

Where NameLang, etc changes acording to selected language

there are more than one tables and they may need to joined

here is how i fill the datagrid

        Dim strSQL As String
        Dim Conn As OleDbConnection

        Dim objDA As OleDbDataAdapter
        Dim objDS As New DataSet

        Conn = New OleDbConnection(GetDSN)
        strSQL = "SELECT * FROM students"

        objDA = New OleDbDataAdapter(strSQL, Conn)
        objDA.Fill(objDS, "mytable")
        'Bind the DataSet to DataGrid.
        txtOutput.SetDataBinding(objDS, "mytable")

        Conn.Close()
        Conn = Nothing


Thanks in advance

Start Free Trial