view datagrid

i have this sql
select emp_no, lname as "Last Name",fname,mi,date_hired,code,address from tblInfo;

i want to view only emp_no, lname,fname,mi, and date_hired in datagrid
with specified column width example: emp_no = 50 and lname=100

how could i do that?

tnx

Take a look at this site: http://www.syncfusion.com/faq/windowsforms/Default.aspx

It has a ton of good tips about the datagrid, and a lot else besides.

Check out item 5.35 for column widths.