private void m_rendersqlserverbutton_Click(object sender, EventArgs e) { SQLServerProvider layer = new SQLServerProvider(m_sqlserverconnectiontext.Text, m_sqlservertablecombo.Text, null); //test connection try { layer.GeoColumn = layer.GetGeoColumn(); //layer.GeoColumn = "MAPINFOOBJECT"; } catch (Exception ex) { MessageBox.Show(this, "Error connection to SQL Server\nMessage: " + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //show map frmMap dlg = new frmMap(layer.MaxBounds, layer.CoordinateSystem, layer); dlg.ShowDialog(); }
private void m_sqlservertablecombo_GotFocus(object sender, System.EventArgs e) { try { if (m_sqlservertablecombo.DataSource != null) { return; } SQLServerProvider conn = new SQLServerProvider(m_sqlserverconnectiontext.Text); string[] tables = conn.GetTablenames(); m_sqlservertablecombo.DataSource = tables; if (tables == null) { m_sqlservertablecombo.DataSource = new string[] { } } ; //don't load again } catch (Exception ex) { MessageBox.Show(this, "Error connecting to SQL Server\nMessage: " + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void m_sqlservertablecombo_GotFocus(object sender, System.EventArgs e) { try { if (m_sqlservertablecombo.DataSource != null) return; SQLServerProvider conn = new SQLServerProvider(m_sqlserverconnectiontext.Text); string[] tables = conn.GetTablenames(); m_sqlservertablecombo.DataSource = tables; if (tables == null) m_sqlservertablecombo.DataSource = new string[] { }; //don't load again } catch (Exception ex) { MessageBox.Show(this, "Error connecting to SQL Server\nMessage: " + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } }