When you set the datasource the grid should show the data. So just comment out the last line.
When setting the datasource, instead of using a dataset, use the datatable. For example:
dataGridView1.DataSource = ds.Tables[0];
If you're still not seeing anything in the grid, put a breakpoint in your code and check that there actually are rows in your datatable.