SqlConnection myConn = new SqlConnection(strConString);
string strSql = "select * from Products";

DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(strSql, myConn);
da.Fill(ds);

DataTable dt = ds.Tables[0];

// The following line filters the data by "CategoryId = 1" and returns an array of DataRow
DataRow[] dRow = dt.Select("CategoryId=1");

for (int i = 0; i < dRow.Length; i++)
{
     Response.Write("
Row " + dRow[i]["ProductName"].ToString());
}