Checked Box & Combobox Pass Null in Data Grid.

See more:

VB

DataGrid

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Da As New SDS.OleDbDataAdapter("Select * from Trip WHERE AgentID = '" & ComboBox1.Text & "' and Country = '" & ComboBox2.Text & "' and Category = '" & ComboBox3.Text & "' and SCategory = '" & ComboBox4.Text & "' and TDate = #" & ComboBox5.Text & "# ; ", connection)
        Dim Ds As New DataSet
        Ds.Clear()
        Try
            Da.Fill(Datas, "Trip")
            DG1.DataSource = Ds
            DG1.DataMember = "Trip"
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
    End Sub

My Error is : This Code is Passes Null in Datagrid, but if I fire the same query in access 2003, it gives me Result without Error.

If I fire the same query with Static Data like where AgentID ='admin' and Country='India' etc. also Vb.Net Fills DataGrid.

This Query also work till combination of four dynamic "DropDown.Text" but whenevervI tried for five "DropDown.Text" it's Passed Null in DataGrid.