This code works normal for normal situation:
The problem with this code is that I must arrange the order of the fields in the select statement. How do I add rows to the datagridview manually and preset the order of the columns by myself?
DataGridView1.DataSource = Datatable1
The reason I want to do this is because I want to add buttons and dtPicker within the datagridview, and I cannot see how I can achieve this using the snippet above. And that creates a second question : how do I embed button and dtPicker to a datagridview?