Suppressing columns in the Data Grid

<i><b>Originally posted by : siva (skaipa@hotmail.com)</b></i><br />Hi,<br /> I am doing a SELECT statement with only 2 fields out of 10 fields. I want to bind this data set to the data grid. The problem I am facing is that it also showing the remaining 8 fields with empty spaces in them.(I am doing a dynamic query so the number of fields in the select statement can vary)<br />How can I display only the fields that I require? <br />Any help is appreciated.<br /><br />Thanks in advance<br />Siva<br />

<i><b>Originally posted by : Sushila Bowalekar (b_sonali@hotmail.com)</b></i><br />Have a look at http://aspfree.com/authors/Sushila_Bowalekar/DynamicBoundColumnsDatagrid.aspx<br /><br />------------<br />siva at 6/12/2002 9:52:02 PM<br /><br />Hi,<br /> I am doing a SELECT statement with only 2 fields out of 10 fields. I want to bind this data set to the data grid. The problem I am facing is that it also showing the remaining 8 fields with empty spaces in them.(I am doing a dynamic query so the number of fields in the select statement can vary)<br />How can I display only the fields that I require? <br />Any help is appreciated.<br /><br />Thanks in advance<br />Siva<br />