Populate A Datagridview With Data - Make The Code Shorter?

is there a way to make this less in code?Usually when im going to populate a datagridview with data I usually do in this way

[code]...

That how I make things harder although there's a function "DataGridView1.DataSource = myDataTable" and put an sql where selecting those data. I just want to use some other method. so how am I able to add some columns row dynamically and if another column of the database need to get how am I able to add it in that loop is there other way and I want the less code nor the shorter code that you can give to me. I just want to learn and make my code more shorter