I created the oleDB adapter and the connections using the wizzird in VS.Net pro. Now in the adapter we can genarate a dataset for the sql qurey. which most of the time is select user.* form User etc.



now the problem comes when i wanted to show the dataset in a datagrid i notice that some of the field i don't need(another word i need to refine the data in the dataset). Is there a way to create the dataset my self using my own OleDBCommand and fill it to a new dataset and then use that in my datagrid?
I'm kind of used to the wizzard so is it possible that you show me some coding Plz^^