Guys,

at the moment I am populating a grid and diplaying it. I want to filter out some of the columns within the grid. Is therea way of doing this

Thanks

Adnan Arab

My Code is: -

private void GridDataFiller()
{
  //String sPath = "\\\\premfs3\\sites\\premium8\\adnanarab66\\databa se\\house.mdb";

  String strConnect = "Provider = Microsoft.Jet.OleDb.4.0; data source=\\\\premfs3\\sites\\premium8\\adnanarab66\\ database\\House.mdb;";
  OleDbConnection objConnection = new OleDbConnection(strConnect);

  String strShowDetails = "SELECT * FROM Houses";
  OleDbDataAdapter objAdapter = new OleDbDataAdapter(strShowDetails, objConnection);

  DataSet objDataSet = new DataSet();
  objAdapter.Fill(objDataSet, "dtHouses");

  DataView dvHouses = new DataView (objDataSet.Tables["dtHouses"]);
  dvHouses.RowFilter = strPriceFilter + " AND (" + strSmokingFilter + ")" + " AND (" + strHouseHoldFilter + ")";

  dgHouse.DataSource = dvHouses;
  dgHouse.DataBind();

}

__________________
Adz - Learning The J2EE Ways.

you can do that using several techniques. One would use the SELECT statement like this:

String strShowDetails = "SELECT id, smokes, houses FROM Houses";

Another way would be in your HTML section. Set AutoGenerateColumns="False" and in between datagrid tags put this:

<Columns>
                    <asp:BoundColumn DataField="ID" ReadOnly="True" Visible="False" />
                    <asp:BoundColumn DataField="smokes" ReadOnly="True" HeaderText="New Smokes" />
<asp:BoundColumn DataField="houses" ReadOnly="True" HeaderText="New houses" />

                </Columns>