I am using an OLEDbDataAdapter to conect to a table in a MS Access database, I am filling the data into a DataSet, and I am also using a DataGrid control to display results. Everything works well (using SQL statement with all fields selected, e.g: SELECT * FROM table1) and all the data are displayed in the DataGrid. However, when I want to choose few fields (e.g. SELECT a, b, c FROM Table1) then the problem I am facing is that the DataGrid displays the fields "a,b and c" but at the same time the other fields (with null as their values). I know that I should be clearing the DataGrid or the DataAdapter (which I am doing by having DataSet.Clear()).
Any Idea for the New Year.