//when clicking "OK" private void btnOK_Click(object sender, EventArgs e) { queryResult = null; SpatiaLiteHelper slh = new SpatiaLiteHelper(); queryResult = slh.ReadFeatureSet(connString, txtQuery.Text); dgQueryResult.DataSource = queryResult.DataTable; //SpatiaLiteHelper slh = new SpatiaLiteHelper(); //foreach (DataGridViewRow r in dgGeometryColumns.Rows) //{ // if (r.Selected) // { // GeometryColumnInfo item = r.DataBoundItem as GeometryColumnInfo; // if (item != null) // { // IFeatureSet fs = slh.ReadFeatureSet(connString, item); // IMapFeatureLayer lay = mainMap.Layers.Add(fs); // //lay.EditMode = false; // } // } //} }
public frmQuery(string dbConnection, IMap map) { InitializeComponent(); connString = dbConnection; mainMap = map; SpatiaLiteHelper slh = new SpatiaLiteHelper(); List <GeometryColumnInfo> geometryColumnList = slh.GetGeometryColumns(dbConnection); //get names of tables List <string> tableNameList = slh.GetTableNames(connString); foreach (string tableName in tableNameList) { try { List <string> colNames = slh.GetColumnNames(connString, tableName); TreeNode nTableName = treeTables.Nodes.Add(tableName); foreach (string cn in colNames) { nTableName.Nodes.Add(cn); } } catch { } } }
/// <summary> /// Shows the add layer window. /// </summary> /// <param name="sender">Sender that raised the event.</param> /// <param name="e">The event args.</param> public void ButtonClick(object sender, EventArgs e) { // check if it's a valid SpatiaLite layer using (OpenFileDialog fd = new OpenFileDialog { Title = Resources.OpenSpatialiteDatabase, Filter = Resources.SpatialiteDatabaseFilter }) { if (fd.ShowDialog() == DialogResult.OK) { string cs = SqLiteHelper.GetSqLiteConnectionString(fd.FileName); string error; var slh = SpatiaLiteHelper.Open(cs, out error); if (slh == null) { MessageBox.Show(string.Format(Resources.DatabaseNotValid, fd.FileName, error)); return; } using (FrmAddLayer frm = new FrmAddLayer(slh, App.Map)) { frm.ShowDialog(); } } } }
public frmQuery(string dbConnection, IMap map) { InitializeComponent(); connString = dbConnection; mainMap = map; SpatiaLiteHelper slh = new SpatiaLiteHelper(); List<GeometryColumnInfo> geometryColumnList = slh.GetGeometryColumns(dbConnection); //get names of tables List<string> tableNameList = slh.GetTableNames(connString); foreach (string tableName in tableNameList) { try { List<string> colNames = slh.GetColumnNames(connString, tableName); TreeNode nTableName = treeTables.Nodes.Add(tableName); foreach (string cn in colNames) { nTableName.Nodes.Add(cn); } } catch { } } }
/// <summary> /// Initializes a new instance of the <see cref="FrmQuery"/> class. /// </summary> /// <param name="slh">The SpatiaLiteHelper that is connected to the database.</param> /// <param name="map">The map layers get added to.</param> public FrmQuery(SpatiaLiteHelper slh, IMap map) { InitializeComponent(); _slh = slh; _mainMap = map; List <GeometryColumnInfo> geometryColumnList = _slh.GetGeometryColumns(); // get names of tables List <string> tableNameList = slh.GetTableNames(); foreach (string tableName in tableNameList) { try { List <string> colNames = slh.GetColumnNames(tableName); TreeNode nTableName = treeTables.Nodes.Add(tableName); foreach (string cn in colNames) { nTableName.Nodes.Add(cn); } } catch { } } }
// when clicking "OK" private void BtnOkClick(object sender, EventArgs e) { _queryResult = null; SpatiaLiteHelper slh = new SpatiaLiteHelper(); _queryResult = slh.ReadFeatureSet(_connString, txtQuery.Text); dgQueryResult.DataSource = _queryResult.DataTable; }
public frmAddLayer(string dbConnection, IMap map) { InitializeComponent(); label2.Text = "Database: " + SQLiteHelper.GetSQLiteFileName(dbConnection); connString = dbConnection; mainMap = map; SpatiaLiteHelper slh = new SpatiaLiteHelper(); List<GeometryColumnInfo> geometryColumnList = slh.GetGeometryColumns(dbConnection); dgGeometryColumns.DataSource = geometryColumnList; }
/// <summary> /// Initializes a new instance of the <see cref="FrmAddLayer"/> class. /// </summary> /// <param name="slh">The SpatiaLiteHelper that is connected to the SQLite database.</param> /// <param name="map">The map the layer will be added to.</param> public FrmAddLayer(SpatiaLiteHelper slh, IMap map) { InitializeComponent(); label2.Text = string.Format(Resources.Database0, SqLiteHelper.GetSqLiteFileName(slh.ConnectionString)); _slh = slh; _mainMap = map; List <GeometryColumnInfo> geometryColumnList = _slh.GetGeometryColumns(); dgGeometryColumns.DataSource = geometryColumnList; }
public frmAddLayer(string dbConnection, IMap map) { InitializeComponent(); label2.Text = "Database: " + SQLiteHelper.GetSQLiteFileName(dbConnection); connString = dbConnection; mainMap = map; SpatiaLiteHelper slh = new SpatiaLiteHelper(); List <GeometryColumnInfo> geometryColumnList = slh.GetGeometryColumns(dbConnection); dgGeometryColumns.DataSource = geometryColumnList; }
/// <summary> /// Initializes a new instance of the <see cref="FrmAddLayer"/> class. /// </summary> /// <param name="dbConnection">The connectionstring to the SQLite database.</param> /// <param name="map">The map the layer will be added to.</param> public FrmAddLayer(string dbConnection, IMap map) { InitializeComponent(); label2.Text = string.Format(Resources.Database0, SqLiteHelper.GetSqLiteFileName(dbConnection)); _connString = dbConnection; _mainMap = map; SpatiaLiteHelper slh = new SpatiaLiteHelper(); List <GeometryColumnInfo> geometryColumnList = slh.GetGeometryColumns(dbConnection); dgGeometryColumns.DataSource = geometryColumnList; }
/// <summary> /// This static method is only meant to be used by the deserializer. /// </summary> /// <param name="filePath">Path of the file that contains the layer that gets loaded.</param> /// <param name="layerName">Name of the layer that should be loaded.</param> /// <returns>The opened layer.</returns> public static IFeatureSet OpenLayer(string filePath, string layerName) { var connectionString = SqLiteHelper.GetSqLiteConnectionString(filePath); var file = SpatiaLiteHelper.Open(connectionString, out string error); if (file == null) { throw new FileLoadException(string.Format(Resources.DatabaseNotValid, filePath, error)); } var fs = file.ReadFeatureSet(layerName); return(fs); }
// when clicking "OK" private void BtnOkClick(object sender, EventArgs e) { SpatiaLiteHelper slh = new SpatiaLiteHelper(); foreach (DataGridViewRow r in dgGeometryColumns.Rows) { if (r.Selected) { GeometryColumnInfo item = r.DataBoundItem as GeometryColumnInfo; if (item != null) { IFeatureSet fs = slh.ReadFeatureSet(_connString, item); _mainMap.Layers.Add(fs); } } } }
//when clicking "OK" private void btnOK_Click(object sender, EventArgs e) { SpatiaLiteHelper slh = new SpatiaLiteHelper(); foreach (DataGridViewRow r in dgGeometryColumns.Rows) { if (r.Selected) { GeometryColumnInfo item = r.DataBoundItem as GeometryColumnInfo; if (item != null) { IFeatureSet fs = slh.ReadFeatureSet(connString, item); IMapFeatureLayer lay = mainMap.Layers.Add(fs); //lay.EditMode = false; } } } }
/// <summary> /// When the plugin is activated. /// </summary> public override void Activate() { // try setting environment variables.. SpatiaLiteHelper.SetEnvironmentVars(); string spatiaLiteGroup = "SpatiaLite"; var bOpenLayer = new SimpleActionItem("Open Layer", ButtonClick) { LargeImage = Resources.spatialite_open_32, SmallImage = Resources.spatialite_open_16, ToolTipText = "Add Layer from SpatiaLite", GroupCaption = spatiaLiteGroup }; App.HeaderControl.Add(bOpenLayer); // query var bQuery = new SimpleActionItem("SpatiaLite Query", BQueryClick) { LargeImage = Resources.spatialite_query_32, SmallImage = Resources.spatialite_query_16, ToolTipText = "Run SpatiaLite Query", GroupCaption = spatiaLiteGroup }; App.HeaderControl.Add(bQuery); // save layer (not implemented yet) var bSaveLayer = new SimpleActionItem("Save Layer", BSaveLayerClick) { LargeImage = Resources.spatialite_save_32, SmallImage = Resources.spatialite_save_16, ToolTipText = "Save Layer to SpatiaLite Database", GroupCaption = spatiaLiteGroup }; App.HeaderControl.Add(bSaveLayer); base.Activate(); }
public void ButtonClick(object sender, EventArgs e) { //check if it's a valid SpatiaLite layer OpenFileDialog fd = new OpenFileDialog(); fd.Title = "Open SpatiaLite database"; fd.Filter = "SpatiaLite database|*.sqlite"; if (fd.ShowDialog() == DialogResult.OK) { string cs = SQLiteHelper.GetSQLiteConnectionString(fd.FileName); bool isValidSchema = SpatiaLiteHelper.CheckSpatiaLiteSchema(cs); if (!isValidSchema) { MessageBox.Show("The database " + fd.FileName + " is not a valid SpatiaLite database. Table geometry_columns not found."); return; } else { frmAddLayer frm = new frmAddLayer(cs, App.Map); frm.Show(); } } }
private void BQueryClick(object sender, EventArgs e) { // check if it's a valid SpatiaLite layer using OpenFileDialog fd = new() { Title = Resources.OpenSpatialiteDatabase, Filter = Resources.SpatialiteDatabaseFilter }; if (fd.ShowDialog() == DialogResult.OK) { string cs = SqLiteHelper.GetSqLiteConnectionString(fd.FileName); var slh = SpatiaLiteHelper.Open(cs, out string error); if (slh == null) { MessageBox.Show(string.Format(Resources.DatabaseNotValid, fd.FileName, error)); return; } using var frm = new FrmQuery(slh, App.Map); frm.ShowDialog(); } }