private void btnExecute_Click(object sender, EventArgs e) { if (m_dsProvider != null) { dgvResults.Rows.Clear(); try { // Comment the following line for versions less or equal v. 2.2 IExpressionEvaluationContext exprEvalContext = new DefaultExpressionEvaluationContext(); IFeatureExpressionFilter filterExpr = null; if (txtFilter.Text.Trim() != string.Empty) { filterExpr = new FeatureExpressionFilter(); filterExpr.Compile(txtFilter.Text, m_dsProvider.Information.Attributes); } Envelope env = m_dsProvider.GetExtent(); List<string> properties = m_dsProvider.Information.GetAttributeNames(); properties.Remove("_geom_"); DataSourceQuery query = new DataSourceQuery(env, 1, null, null, properties); IFeatureDataReader dataReader = m_dsProvider.GetFeatureReader(query, FeatureFactory.Default); int i = 0; if (dataReader != null) { int rowsLimit = (int)nudRowsLimit.Value; while (dataReader.Read()) { Feature feature = dataReader.GetFeature(); if (rowsLimit > 0 && i >= rowsLimit) { break; } bool bFeaturePass = true; if (filterExpr != null) { // Apply a given expression to filter features from the data source. // Change the following line for versions less or equal v. 2.2 by replacing the expression with filterExpr.Pass(feature) bFeaturePass = filterExpr.Pass(feature, exprEvalContext); } if (bFeaturePass) { DataGridViewRow row = (DataGridViewRow)dgvResults.Rows[0].Clone(); object[] values = new object[feature.Attributes.Count]; int j = 0; // Enumerate feature properties and fill the grid view. foreach (string attr in feature.Attributes.EnumerateNames()) { object value = feature.GetPropertyValue(attr); if (attr == "_geom_") value = value.ToString().Replace("MapSurfer.Geometries.", ""); values[j] = value; row.Cells[j].Value = value; j++; } row.SetValues(values); dgvResults.Rows.Add(row); i++; } } DisposeUtility.Dispose(ref dataReader); } lblRows.Text = i.ToString() + " rows"; UpdateMessage(string.Format("{0} row(s) fetched.", i)); } catch (Exception ex) { UpdateMessage("Exception: " + ex.Message); } } }
private void btnExecute_Click(object sender, EventArgs e) { if (m_dsProvider != null) { dgvResults.Rows.Clear(); try { // Comment the following line for versions less or equal v. 2.2 IExpressionEvaluationContext exprEvalContext = new DefaultExpressionEvaluationContext(); IFeatureExpressionFilter filterExpr = null; if (txtFilter.Text.Trim() != string.Empty) { filterExpr = new FeatureExpressionFilter(); filterExpr.Compile(txtFilter.Text, m_dsProvider.Information.Attributes); } Envelope env = m_dsProvider.GetExtent(); List <string> properties = m_dsProvider.Information.GetAttributeNames(); properties.Remove("_geom_"); DataSourceQuery query = new DataSourceQuery(env, new Tuple <double, double>(1.0, 1.0), null, null, properties); IFeatureDataReader dataReader = m_dsProvider.GetFeatureReader(query, FeatureFactory.Default); int i = 0; if (dataReader != null) { int rowsLimit = (int)nudRowsLimit.Value; while (dataReader.Read()) { Feature feature = dataReader.GetFeature(); if (rowsLimit > 0 && i >= rowsLimit) { break; } bool bFeaturePass = true; if (filterExpr != null) { // Apply a given expression to filter features from the data source. // Change the following line for versions less or equal v. 2.2 by replacing the expression with filterExpr.Pass(feature) bFeaturePass = filterExpr.Pass(feature, exprEvalContext); } if (bFeaturePass) { DataGridViewRow row = (DataGridViewRow)dgvResults.Rows[0].Clone(); object[] values = new object[feature.Attributes.Count]; int j = 0; // Enumerate feature properties and fill the grid view. foreach (string attr in feature.Attributes.EnumerateNames()) { object value = feature.GetPropertyValue(attr); if (attr == "_geom_") { value = value.ToString().Replace("MapSurfer.Geometries.", ""); } values[j] = value; row.Cells[j].Value = value; j++; } row.SetValues(values); dgvResults.Rows.Add(row); i++; } } DisposeUtility.Dispose(ref dataReader); } lblRows.Text = i.ToString() + " rows"; UpdateMessage(string.Format("{0} row(s) fetched.", i)); } catch (Exception ex) { UpdateMessage("Exception: " + ex.Message); } } }