private string GetForeignKeyReferenceTableName(string owner, string tableName, string columnName) { var conn = new IngresConnection(_connectionString); conn.Open(); try { using (conn) { using (var tableCommand = conn.CreateCommand()) { tableCommand.CommandText = "SELECT p.table_name " + "FROM iiref_constraints rc " + "INNER JOIN iikeys p " + "ON p.schema_name = rc.unique_schema_name " + "AND p.constraint_name = rc.unique_constraint_name " + "INNER JOIN iiconstraints c " + "ON c.schema_name = rc.ref_schema_name " + "AND c.constraint_name = rc.ref_constraint_name " + "INNER JOIN iikeys f " + "ON f.schema_name = rc.ref_schema_name " + "AND f.constraint_name = rc.ref_constraint_name " + "AND p.key_position = f.key_position " + $"WHERE f.schema_name = '{owner}' " + $"AND f.table_name = '{tableName}' " + $"AND f.column_name = '{columnName}'"; return(tableCommand.ExecuteScalar().ToString()); } } } finally { conn.Close(); } }
private void metroButton1_Click(object sender, EventArgs e) { IngresConnection con = new IngresConnection(Login.myConnectionString); con.Open(); IngresCommand cmd = new IngresCommand(); cmd.Connection = con; cmd.CommandText = "rol_create"; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new IngresParameter("t_id_rol", IngresType.Decimal)); cmd.Parameters.Add(new IngresParameter("t_nombre", IngresType.VarChar)); cmd.Parameters["t_id_rol"].Value = 0; cmd.Parameters["t_nombre"].Value = this.nombre.Text; try { cmd.ExecuteNonQuery(); MetroMessageBox.Show(this, "Elemento creado correctamente.", "Nota", MessageBoxButtons.OK, MessageBoxIcon.Question); } catch (IngresException c) { MetroMessageBox.Show(this, c.ErrorCode + c.Message, "Error"); } con.Close(); this.read(); }
static public void Main() { string myConnectionString = "Host=myserver.mycompany.com;" + "User Id=myname;PWD=mypass;" + "Database=mydatabase"; using (DbConnection conn = new IngresConnection()) { conn.ConnectionString = myConnectionString; conn.Open(); // open the Ingres connection string cmdtext = "select table_owner, table_name, " + " create_date from iitables " + " where table_type in ('T','V') and " + " table_name not like 'ii%' and" + " table_name not like 'II%'"; DbCommand cmd = conn.CreateCommand(); cmd.CommandText = cmdtext; DataSet ds = new DataSet("my_list_of_tables"); // read the data using the DataAdapter method DbDataAdapter adapter = new IngresDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds); // execute the query and fill the dataset // write the dataset to an XML file ds.WriteXml("c:/temp/temp.xml"); } // close the connection } // end Main()
public static async Task <object> ExecuteScalarAsync(this IngresConnection conn, string sql, IngresTransaction tx = null) { var cmd = tx == null ? new IngresCommand(sql, conn) : new IngresCommand(sql, conn, tx); using (cmd) return(await cmd.ExecuteScalarAsync()); }
static void Main(string[] args) { string SQLStatement = "select * from revenue"; // SQLStatement = "delete from revenue"; // SQLStatement = "insert into revenue(myid, material, revenue) values(1, 'Flower', 12.34)"; // SQLStatement = "insert into revenue(myid, material, revenue) values(2, 'car', 1.34)"; // SQLStatement = "insert into revenue(myid, material, revenue) values(3, '花', 26.989)"; // SQLStatement = "insert into revenue(myid, material, revenue) values(3, '汽车',26.989)"; IngresConnection con = new IngresConnection(string.Format("Host={0};Database={1};Uid={2};Pwd={3}", "XXX", "demodb", "Administrator", "HX")); IngresDataAdapter da = new IngresDataAdapter(new IngresCommand(SQLStatement, con)); DataTable sqlresult = new DataTable(); da.Fill(sqlresult); con.Close(); da.Dispose(); foreach (DataColumn sqlcol in sqlresult.Columns) { Console.WriteLine(sqlcol.DataType); } Console.WriteLine(sqlresult.Rows.Count); Console.Read(); }
public override object EditValue( ITypeDescriptorContext context, IServiceProvider provider, object value) { if (context != null && context.Instance != null && provider != null) { IWindowsFormsEditorService edSvc = (IWindowsFormsEditorService)provider.GetService( typeof(IWindowsFormsEditorService)); if (edSvc != null) { // set connection string into an IngresConnection IngresConnection connection = new IngresConnection((string)value); // call the dialog for building/modifying the connection str ConnectionEditor editor = new ConnectionEditor(connection); value = connection.ConnectionString; // return updated string } // end if (edSvc != null) } // end if context is OK return value; }
public static object ExecuteScalar(this IngresConnection conn, string sql, IngresTransaction tx = null) { var cmd = tx == null ? new IngresCommand(sql, conn) : new IngresCommand(sql, conn, tx); using (cmd) return(cmd.ExecuteScalar()); }
private void Delete_Click(object sender, EventArgs e) { IngresConnection con = new IngresConnection(Login.myConnectionString); con.Open(); IngresCommand cmd = new IngresCommand(); cmd.Connection = con; cmd.CommandText = "rol_delete"; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new IngresParameter("t_id_rol", IngresType.Decimal)); cmd.Parameters["t_id_rol"].Value = int.Parse(this.metroTextBox1.Text); IngresTransaction trans = con.BeginTransaction(); cmd.Transaction = trans; try { cmd.ExecuteNonQuery(); trans.Commit(); MetroMessageBox.Show(this, "Elemento eliminado correctamente.", "Nota", MessageBoxButtons.OK, MessageBoxIcon.Question); } catch (IngresException c) { MetroMessageBox.Show(this, c.ErrorCode + c.Message, "Error"); } con.Close(); this.read(); }
private string GetConstraintName(string owner, string tableName, string columnName) { var conn = new IngresConnection(_connectionString); conn.Open(); try { using (conn) { using (var tableDetailsCommand = conn.CreateCommand()) { tableDetailsCommand.CommandText = string.Format("SELECT k.constraint_name " + "FROM iikeys k " + "INNER JOIN iiconstraints c " + "ON k.constraint_name = c.constraint_name " + "WHERE c.constraint_type = 'R' " + "AND k.schema_name = '{0}' " + "AND k.table_name = '{1}' " + "AND k.column_name = '{2}'", owner, tableName, columnName); var result = tableDetailsCommand.ExecuteScalar(); return(result == null ? String.Empty : result.ToString()); } } } finally { conn.Close(); } }
public Task <List <Table> > GetTables(string owner) { var tables = new List <Table>(); var conn = new IngresConnection(_connectionString); conn.Open(); try { using (conn) { var tableCommand = conn.CreateCommand(); tableCommand.CommandText = String.Format("SELECT table_name " + "FROM iitables " + "WHERE table_owner = '{0}' " + "AND table_type in ('T', 'V') " + "AND table_name NOT LIKE 'ii%'", owner); var sqlDataReader = tableCommand.ExecuteReader(CommandBehavior.CloseConnection); while (sqlDataReader.Read()) { var tableName = sqlDataReader.GetString(0).TrimEnd(); tables.Add(new Table { Name = tableName }); } } tables.Sort((x, y) => String.CompareOrdinal(x.Name, y.Name)); } finally { conn.Close(); } return(Task.FromResult(tables)); }
private IList <HasMany> DetermineHasManyRelationships(Table table) { var hasManyRelationships = new List <HasMany>(); var conn = new IngresConnection(_connectionString); conn.Open(); using (conn) { using (var command = conn.CreateCommand()) { command.CommandText = "SELECT f.table_name " + "FROM iiref_constraints rc " + "INNER JOIN iikeys p " + "ON p.schema_name = rc.unique_schema_name " + "AND p.constraint_name = rc.unique_constraint_name " + "INNER JOIN iiconstraints c " + "ON c.schema_name = rc.ref_schema_name " + "AND c.constraint_name = rc.ref_constraint_name " + "INNER JOIN iikeys f " + "ON f.constraint_name = rc.ref_constraint_name " + "AND p.key_position = f.key_position " + $"WHERE p.schema_name = '{table.Owner}' " + $"AND p.table_name = '{table.Name}'"; using (var reader = command.ExecuteReader()) { while (reader.Read()) { hasManyRelationships.Add(new HasMany { Reference = reader.GetString(0).TrimEnd(), }); } } return(hasManyRelationships); } } }
private bool IsForeignKey(string owner, string tableName, string columnName) { var conn = new IngresConnection(_connectionString); conn.Open(); try { using (conn) { using (var tableDetailsCommand = conn.CreateCommand()) { tableDetailsCommand.CommandText = "SELECT COUNT(0) " + "FROM iikeys k " + "INNER JOIN iiconstraints c " + "ON k.constraint_name = c.constraint_name " + "WHERE c.constraint_type = 'R' " + $"AND k.schema_name = '{owner}' " + $"AND k.table_name = '{tableName}' " + $"AND k.column_name = '{columnName}'"; var obj = tableDetailsCommand.ExecuteScalar(); int result; if (obj != null && Int32.TryParse(obj.ToString(), out result)) { return(result > 0); } } } } finally { conn.Close(); } return(false); }
public Task <IList <string> > GetOwners() { IList <string> owners = new List <string>(); var conn = new IngresConnection(_connectionString); conn.Open(); try { using (conn) { var tableCommand = conn.CreateCommand(); tableCommand.CommandText = "SELECT DISTINCT table_owner FROM iitables WHERE table_owner <> '$ingres'"; var sqlDataReader = tableCommand.ExecuteReader(CommandBehavior.CloseConnection); while (sqlDataReader.Read()) { var ownerName = sqlDataReader.GetString(0).TrimEnd(); owners.Add(ownerName); } } } finally { conn.Close(); } return(Task.FromResult(owners)); }
public static List <Employer> GetDeliveryReport(string hub_code) { using (IngresConnection db = new IngresConnection(ConfigurationManager.ConnectionStrings["pfmdb"].ConnectionString)) { List <Employer> data = new List <Employer>(); db.Open(); try { var key = "batchno" + hub_code; // Try to get the object from the cache //data = _cache[key] as List<Employer>; //if (data == null) //{ db.Query("set lockmode session where readlock=nolock"); data = db.Query <Employer>("select batchno,cutdate " + "from lo_stl_billing_employer " + "where ifnull(batchno,'')<>'' " + "group by batchno,cutdate").ToList(); // _cache.Set(key, data, DateTimeOffset.Now.AddMinutes(1)); // } } catch (Exception ex) { } db.Close(); db.Dispose(); return(data); } }
public static List <Members> ReportHQPSLF132(string batchno) { using (IngresConnection db = new IngresConnection(ConfigurationManager.ConnectionStrings["pfmdb"].ConnectionString)) { List <Members> data = new List <Members>(); db.Open(); try { db.Query("set lockmode session where readlock=nolock"); if (batchno.Contains("ER")) { data = db.Query <Members>("select a.status_code,a.batchno,a.eyername as fname," + "b.branch_name, int2(0) as indiv_payor,a.eyeraddr as home_address,a.zipcode from lo_stl_billing_employer a " + "inner join hdmf_branches b on b.branch_code=a.branch_code " + "where batchno=@batchno and a.status_code=10", new { batchno = batchno }).ToList(); } else { data = db.Query <Members>("select a.lname,a.fname,a.mid,a.name_ext,e.branch_name," + " home_address,int2(1) as indiv_payor,a.zipcode from lo_stl_billing_members a inner join hdmf_branches e on " + "e.branch_code=a.branch_code where a.status_code=10 and a.indiv_payor=1 and batchno=@batchno", new { batchno = batchno }).ToList(); } db.Close(); db.Dispose(); } catch (Exception ex) { } return(data); } }
/// <summary> /// Connect to two databases while automatically enlisting in the ambient Transaction, /// and execute two non-query SQL commands under the TransactionScope. /// Commit the Transaction by marking the TransactionScope complete, /// if issueScopeComplete argument is set true for testing purposes. /// </summary> /// <param name="connString1">ConnectionString for database 1.</param> /// <param name="connString2">ConnectionString for database 2.</param> /// <param name="commandText1">Non-query CommandText to execute against database 1.</param> /// <param name="commandText2">Non-query CommandText to execute against database 2.</param> /// <param name="issueScopeComplete">If true, issue TransactionScope.Complete()</param> static void ExecuteNonQueryWithinTransactionScope( string connString1, string connString2, string commandText1, string commandText2, bool issueScopeComplete) { Console.WriteLine("\n\tUpdateUsingTransactionScope...\n"); using (TransactionScope scope = new TransactionScope()) { using (IngresConnection conn1 = new IngresConnection(connString1)) { using (IngresConnection conn2 = new IngresConnection(connString2)) { Console.WriteLine("\tIngresConnection1.Open()..."); // Open the connection to the database and // enlist in the ambient Transaction using MSDTC conn1.Open(); Console.WriteLine("\tIngresConnection1.Open() complete\n"); Console.WriteLine("\tIngresConnection2.Open()..."); // Open the connection to the database and // enlist in the ambient Transaction using MSDTC conn2.Open(); Console.WriteLine("\tIngresConnection2.Open() complete\n"); try { IngresCommand cmd1 = conn1.CreateCommand(); cmd1.CommandText = commandText1; cmd1.ExecuteNonQuery(); IngresCommand cmd2 = conn2.CreateCommand(); cmd2.CommandText = commandText2; cmd2.ExecuteNonQuery(); // mark the Transaction complete // mark the Transaction complete if (issueScopeComplete) // test debug flag for testing scope.Complete { Console.WriteLine("\tTransactionScope completing..."); scope.Complete(); Console.WriteLine("\tTransactionScope complete\n"); } // note: TransactionScope will not be committed until // TransactionScope Dispose() is called. } catch (Exception ex) { string s = ex.ToString(); Console.WriteLine("\n\tApplication throws Exception!! " + s + "\n"); throw; } } // end using (IngresConnection2) // closes and disposes conn2 } // end using (IngresConnection1) // closes and disposes conn1 Console.WriteLine("\tTransactionScope.Dispose()..."); } // end using (TransactionScope) // calls System.Transactions.Dispose() --> System.Transactions.CommittableTransaction.Commit Console.WriteLine("\tTransactionScope.Dispose() complete\n"); } // end ExecuteNonQueryWithinTransactionScope
public static List <Hub> GetAllHub() { using (IngresConnection db = new IngresConnection(ConfigurationManager.ConnectionStrings["pfmdb"].ConnectionString)) { db.Query("set lockmode session where readlock=nolock"); return(db.Query <Hub>("SELECT * FROM hdmf_hub_master").ToList()); } }
public static List <Branches> GetAllBranches(string hub_code) { using (IngresConnection db = new IngresConnection(ConfigurationManager.ConnectionStrings["pfmdb"].ConnectionString)) { db.Query("set lockmode session where readlock=nolock"); return(db.Query <Branches>("SELECT * FROM hdmf_branches where hub_code=@hub_code", new{ hub_code = hub_code }).ToList()); } }
public static string Remove(int id) { using (IngresConnection db = new IngresConnection(ConfigurationManager.ConnectionStrings["pfmdb"].ConnectionString)) { db.Query("set lockmode session where readlock=nolock"); db.Query("delete from lo_stl_billing_users where id=@id", new { id = id }); } return("Ok"); }
static void UsingIngresConnection(IngresConnection connection, Action <DbConnection> action) { using (IngresConnection conn = (IngresConnection)connection.Clone()) { conn.Open(); action(conn); // using's Dispose will close conn } // end using clone of IngresConnection }
public static Users GetUserEdit(int id) { using (IngresConnection db = new IngresConnection(ConfigurationManager.ConnectionStrings["pfmdb"].ConnectionString)) { db.Query("set lockmode session where readlock=nolock"); return(db.Query <Users>("SELECT * FROM lo_stl_billing_users a " + "where id=@id", new { id = id }).SingleOrDefault()); } }
public static List <CutOff> GetCutOffs(string hub_code) { using (IngresConnection db = new IngresConnection(ConfigurationManager.ConnectionStrings["pfmdb"].ConnectionString)) { db.Query("set lockmode session where readlock=nolock"); return(db.Query <CutOff>("select cutdate,(date_format(cutdate,'%M %Y')) as desc from lo_stl_billing_employer " + "where hub_code=@hub_code " + "group by cutdate order by cutdate desc", new { hub_code = hub_code }).ToList()); } }
public static List <Users> GetAllUsers() { using (IngresConnection db = new IngresConnection(ConfigurationManager.ConnectionStrings["pfmdb"].ConnectionString)) { db.Query("set lockmode session where readlock=nolock"); return(db.Query <Users>("SELECT a.*,b.hub_name,c.branch_name FROM lo_stl_billing_users a " + "inner join hdmf_hub_master b on b.hub_code=a.hub_code " + "inner join hdmf_branches c on c.branch_code=a.branch_code ").ToList()); } }
public static List <Employer> GetEmployer(DateTime cutdate, string hub_code) { using (IngresConnection db = new IngresConnection(ConfigurationManager.ConnectionStrings["pfmdb"].ConnectionString)) { db.Query("set lockmode session where readlock=nolock"); return(db.Query <Employer>("SELECT distinct a.*,b.address as branch_address,b.contact_no as branch_contactno FROM lo_stl_billing_employer a " + "inner join hdmf_branches b on b.branch_code=a.branch_code " + "where a.cutdate=@cutdate and a.hub_code=@hub_code", new { cutdate = cutdate.ToString("MM/dd/yyyy"), hub_code = hub_code }).ToList()); } }
public static Users GetUser(string username) { using (IngresConnection db = new IngresConnection(ConfigurationManager.ConnectionStrings["pfmdb"].ConnectionString)) { db.Query("set lockmode session where readlock=nolock"); return(db.Query <Users>("SELECT a.*,b.hub_name FROM lo_stl_billing_users a " + "inner join hdmf_hub_master b on b.hub_code=a.hub_code " + "where a.username=@username", new { username = username }).SingleOrDefault()); } }
/// <summary> /// Gets the Id for the current application. /// </summary> /// <param name="conn">The Ingres connection to use.</param> /// <param name="tran">The Ingres transaction to use.</param> /// <returns>The Id for the current application.</returns> private string GetApplicationId(IngresConnection conn, IngresTransaction tran) { string id = null; string sql = @" SELECT ApplicationId FROM aspnet_Applications WHERE LoweredApplicationName = ? "; // Create the new command and enrol in the current transaction IngresCommand cmd = new IngresCommand(sql, this.conn); cmd.Transaction = this.tran; cmd.Parameters.Add("LoweredApplicationName", DbType.String).Value = this.config.ApplicationName.ToLower(); conn.Open(); IngresDataReader reader = cmd.ExecuteReader(); if (reader != null) { if (reader.HasRows) { reader.Read(); // Retrieve the Id id = DBUtil.ColValAsString(reader, "ApplicationId"); reader.Close(); } else { // Close the reader. reader.Close(); // We don't have an application so create one. this.CreateApplication(this.config.ApplicationName, out id); } } // Mark the application Id as current so that we don't have to fetch it from the database // again unless it changes. this.config.IsApplicationIdCurrent = true; // Close the connection conn.Close(); return(id); }
/// <summary> /// Enumerate the items for the Ingres data objects of the /// specified type (e.g. Index), with the specified restrictions /// and sort string. /// </summary> /// <param name="typeName">Type name of the object to enumerate.</param> /// <param name="items">The items (strings) to enumerate.</param> /// <param name="restrictions">Filtering restrictions.</param> /// <param name="sort">ORDER BY sort specification.</param> /// <param name="parameters"></param> /// <returns></returns> public override DataReader EnumerateObjects( string typeName, object[] items, object[] restrictions, string sort, object[] parameters) { //System.Windows.Forms.MessageBox.Show( // "EnumerateObjects Called", "IngresDataObjectEnumerator"); if (typeName == null) // safety check; should not happen { throw new ArgumentNullException("typeName"); } // retrieve the Ingres data provider connection that // supports the the current connection. IngresConnection conn = Connection.GetLockedProviderObject() as IngresConnection; if (conn == null) { throw new ArgumentException( "EnumerateObjects does not have the correct " + "IngresConnection type for the underlying connection."); } try { if (Connection.State != DataConnectionState.Open) { Connection.Open(); } switch (typeName) { case IngresDataObjectTypes.Root: System.Data.DataTable dt = conn.GetSchema("Root"); return(new AdoDotNetDataTableReader(dt)); } // end switch return(adoDataObjectEnumerator.EnumerateObjects( typeName, items, restrictions, sort, parameters)); } finally { // Unlock the DDEX Provider object Connection.UnlockProviderObject(); } } // EnumerateObjects
} // end ExecuteNonQueryWithinExplicitTransactionScope /// <summary> /// Open a database and execute a non-query SQL string. /// </summary> /// <param name="connString"></param> /// <param name="commandText"></param> static void ExecuteNonQuery( string connString, string commandText) { using (IngresConnection conn = new IngresConnection(connString)) { conn.Open(); IngresCommand cmd = conn.CreateCommand(); cmd.CommandText = commandText; cmd.ExecuteNonQuery(); } // end using (IngresConnection conn) } // end ExecuteNonQuery
private void Update_Click(object sender, EventArgs e) { IngresConnection con = new IngresConnection(Login.myConnectionString); con.Open(); IngresCommand cmd = new IngresCommand(); cmd.Connection = con; cmd.CommandText = "empleado_update"; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new IngresParameter("t_id_empleado", IngresType.Decimal)); cmd.Parameters.Add(new IngresParameter("t_primer_nombre", IngresType.VarChar)); cmd.Parameters.Add(new IngresParameter("t_segundo_nombre", IngresType.VarChar)); cmd.Parameters.Add(new IngresParameter("t_primer_apellido", IngresType.VarChar)); cmd.Parameters.Add(new IngresParameter("t_segundo_apellido", IngresType.VarChar)); cmd.Parameters.Add(new IngresParameter("t_calle", IngresType.VarChar)); cmd.Parameters.Add(new IngresParameter("t_avenida", IngresType.VarChar)); cmd.Parameters.Add(new IngresParameter("t_num_casa", IngresType.VarChar)); cmd.Parameters.Add(new IngresParameter("t_ciudad", IngresType.VarChar)); cmd.Parameters.Add(new IngresParameter("t_departamento", IngresType.VarChar)); cmd.Parameters.Add(new IngresParameter("t_referencia", IngresType.VarChar)); cmd.Parameters.Add(new IngresParameter("t_correo_primario", IngresType.VarChar)); cmd.Parameters.Add(new IngresParameter("t_correo_secundario", IngresType.VarChar)); cmd.Parameters.Add(new IngresParameter("t_fecha_nacimiento", IngresType.Date)); cmd.Parameters.Add(new IngresParameter("t_fecha_inicio", IngresType.Date)); cmd.Parameters["t_id_empleado"].Value = int.Parse(this.id.Text); cmd.Parameters["t_primer_nombre"].Value = this.prinom.Text; cmd.Parameters["t_segundo_nombre"].Value = this.senom.Text; cmd.Parameters["t_primer_apellido"].Value = this.priape.Text; cmd.Parameters["t_segundo_apellido"].Value = this.seape.Text; cmd.Parameters["t_calle"].Value = this.ca.Text; cmd.Parameters["t_avenida"].Value = this.avenida.Text; cmd.Parameters["t_num_casa"].Value = this.numcasa.Text; cmd.Parameters["t_ciudad"].Value = this.ciudad.Text; cmd.Parameters["t_departamento"].Value = this.departamento.Text; cmd.Parameters["t_referencia"].Value = this.referencia.Text; cmd.Parameters["t_correo_primario"].Value = this.pricorreo.Text; cmd.Parameters["t_correo_secundario"].Value = this.secorreo.Text; cmd.Parameters["t_fecha_nacimiento"].Value = this.metroDateTime1.Value.ToString("yyyy-MM-dd"); cmd.Parameters["t_fecha_inicio"].Value = this.metroDateTime2.Value.ToString("yyyy-MM-dd"); try { cmd.ExecuteNonQuery(); MetroMessageBox.Show(this, "Elemento actualizado correctamente.", "Nota", MessageBoxButtons.OK, MessageBoxIcon.Question); } catch (IngresException c) { MetroMessageBox.Show(this, c.ErrorCode + c.Message, "Error"); } con.Close(); this.read(); }
/// <summary> /// Handles the press of the test connection string button. /// </summary> /// <param name="sender">The sender.</param> /// <param name="e">The event arguments.</param> private void TestConnectionString(object sender, EventArgs e) { this.btnTest.Enabled = false; IngresConnection conn = new IngresConnection(); if (this.tbConnectionString.Text.Trim() == string.Empty) { MessageBox.Show("A connection string must be entered."); this.btnTest.Enabled = true; return; } try { conn.ConnectionString = this.tbConnectionString.Text; } catch (Exception) { this.tbConnectionResult.Text = "Invalid connection string."; this.btnTest.Enabled = true; return; } try { conn.Open(); this.tbConnectionResult.Text = "Successfully opened a connection!"; MessageBox.Show("A connection to the database was successfully opened!\n\nCopy the generated connection string for use in the web config file.", "Successful Connection"); } catch (Exception ex) { this.tbConnectionResult.Text = ex.Message; } finally { if (conn.State != ConnectionState.Closed) { conn.Close(); } conn = null; this.btnTest.Enabled = true; } }
private IngresConnection GetConnection(CustomListData data) { data.Properties.TryGetValue("Host", StringComparison.OrdinalIgnoreCase, out var Host); data.Properties.TryGetValue("Database", StringComparison.OrdinalIgnoreCase, out var Database); data.Properties.TryGetValue("Username", StringComparison.OrdinalIgnoreCase, out var Username); data.Properties.TryGetValue("Password", StringComparison.OrdinalIgnoreCase, out var Password); IngresConnection con = new IngresConnection(string.Format("Host={0};Database={1};Uid={2};Pwd={3}", Host, Database, Username, Password)); con.Open(); return(con); }
protected override IComponent[] CreateComponentsCore(System.ComponentModel.Design.IDesignerHost host) { //MessageBox.Show("ConnectionToolboxItem.CreateComponentsCore called!"); const string prefix = VSNETConst.shortTitle; // "Ingres" IContainer designerHostContainer = host.Container; //ComponentCollection components = null; ArrayList newComponents = new ArrayList(); ArrayList newCommandComponents = new ArrayList(); string name; if (designerHostContainer == null) // safety check return null; IngresConnection connection = new IngresConnection(); // Once a reference to an assembly has been added to this service, // this service can load types from names that // do not specify an assembly. ITypeResolutionService resService = (ITypeResolutionService)host.GetService(typeof(ITypeResolutionService)); System.Reflection.Assembly assembly = connection.GetType().Module.Assembly; if (resService != null) { resService.ReferenceAssembly(assembly.GetName()); // set the assembly name to load types from } name = DesignerNameManager.CreateUniqueName( designerHostContainer, prefix, "Connection"); try { designerHostContainer.Add(connection, name); newComponents.Add(connection); } catch (ArgumentException ex) { string exMsg = ex.ToString() + "\nRemove IngresConnection component '" + name + "'" + " that is defined outside of the designer. "; MessageBox.Show(exMsg, "Add " + name + " failed"); return null; } // invoke the wizard to create the connection and query ConnectionEditor wizard = new ConnectionEditor(connection); return (IComponent[])(newComponents.ToArray(typeof(IComponent))); //return base.CreateComponentsCore(host); }
internal ConnectionEditor(IngresConnection connectionParm) { connection = connectionParm; // format the connection string in key/value pairs nv = ConnectStringConfig.ParseConnectionString( connection.ConnectionString); // the editor will update the key/value pairs Form dlgConnection = new ConnectionEditorForm(nv); DialogResult result = dlgConnection.ShowDialog(); if (result == DialogResult.Cancel) // if Cancel button, return { //MessageBox.Show("Connection DialogResult.Cancel", "ConnectionEditor"); return; } // else (result == DialogResult.OK) // if Next button, go on // rebuild the updated key/value pairs back into a connection string connection.ConnectionString = ConnectStringConfig.ToConnectionString(nv); }
internal ConnectionEditor( IngresDataAdapter adapter, System.ComponentModel.Design.IDesignerHost host) { if (adapter != null && adapter.SelectCommand != null && adapter.SelectCommand.Connection != null) connection = adapter.SelectCommand.Connection; else connection = new IngresConnection(); // format the connection string in key/value pairs nv = ConnectStringConfig.ParseConnectionString( connection.ConnectionString); // the editor will update the key/value pairs Form dlgConnection = new ConnectionEditorForm(nv); DialogResult result = dlgConnection.ShowDialog(); if (result == DialogResult.Cancel) // if Cancel button, return { //MessageBox.Show("Connection DialogResult.Cancel", "ConnectionEditor"); return; } // else (result == DialogResult.OK) // if Next button, go on // rebuild the updated key/value pairs back into a connection string connection.ConnectionString = ConnectStringConfig.ToConnectionString(nv); // connect the Connection object to the four Adapter commands if (adapter != null) { if (adapter.SelectCommand != null) adapter.SelectCommand.Connection = connection; if (adapter.InsertCommand != null) adapter.InsertCommand.Connection = connection; if (adapter.UpdateCommand != null) adapter.UpdateCommand.Connection = connection; if (adapter.DeleteCommand != null) adapter.DeleteCommand.Connection = connection; } }
private void TestConnection(string connectionString) { IngresConnection connection = new IngresConnection(connectionString); Cursor cursor = Cursor.Current; // save cursor, probably Arrow Cursor.Current = Cursors.WaitCursor; // hourglass cursor try // to open the connection { connection.Open(); // try opening the connection } finally { Cursor.Current = cursor; // restore Arrow cursor } connection.Close(); }
public QueryDesignerForm( IngresConnection connection, string commandText) { // // Required for Windows Form Designer support // InitializeComponent(); // remember the command text and connection to work against if (commandText != null) { string savedConnectionString; // saved connection string if (commandText != null) this.CommandText = commandText.Trim(); this.Connection = connection; if (this.Connection != null) { Cursor cursor = Cursor.Current; // save cursor, probably Arrow Cursor.Current = Cursors.WaitCursor; // hourglass cursor // save the connection because 'Persist Security Info' // option will destroy the password during open savedConnectionString = this.Connection.ConnectionString; try // to open the connection { this.Connection.Open(); // try opening the connection _catalog= this.Connection.OpenCatalog(); } catch (Exception ex) { MessageBox.Show( ex.ToString(), VSNETConst.shortTitle + " Query Designer Server Is Not Available"); this.Connection = null; } finally { Cursor.Current = cursor; // restore Arrow cursor //restore the ConnectionString if changed by Open() if (this.Connection != null && this.Connection.ConnectionString!= savedConnectionString) this.Connection.ConnectionString = savedConnectionString; } } } }