I have a union select query that populates a dataset which in turn fills up a datagrid. When the datagrid is populated it has a + when the click the + it read Table and then when you click table it displays the data in the datagrid. How can I get the data to display immediately.
MySQL = "Select Firstname, MiddleName, lastname, 'ABSENTEE' as SOURCE from absentee where lastname like '" & lname & "%' UNION " & _
"Select Firstname, MiddleName, lastname, 'NLC' from NLC as SOURCE where lastname like '" & lname & "%' UNION " & _
"Select ownername1, '' ,'','PROPERTY_TAX' as SOURCE from propertytax where ownername1 like '" & lname & "%'"
Dim MyDataSet As New DataSet
'DataGrid1.DataMember = "MyDataAdapter"
DataGrid1.DataSource = MyDataSet