How to dispaly certain no of columns after binding the datacontrol to a dataset

Hi Kavita 

Select DatagridView then DataGridview Tasks and after you can click on Preview Data--Privew. In that pane, you will see "columns :*** Rows:***"

I think its solve your post
Thanks

use 'top 20' like statement to display certain number of records. and in column use defined column names, like

select id, name, add from tablename;  
//no matter how my columns we have in this table but we only see 3 here.

or 

select top 20 id, name, add from tablename;


hope this helps.