private void btnDB2Connection_Click(object sender, EventArgs e) { string message = string.Empty; try { IBM.Data.DB2.DB2Connection conn = ConnectDb(); message = "DB2 Connection Successful !"; conn.Close(); } catch (Exception ex) { message = ex.Message; } MessageBox.Show(message, "Import from DB2 Utility", MessageBoxButtons.OK, MessageBoxIcon.Information); }
private void btnPublishData_Click(object sender, EventArgs e) { string sQuery1 = string.Empty; string sQuery2 = string.Empty; string sQuery3 = string.Empty; string message = string.Empty; IBM.Data.DB2.DB2Connection conn = null; DataTable dt = new DataTable("Table1"); try { conn = ConnectDb(); switch (cmbTransactionType.SelectedIndex) { case 0: sQuery1 = "SELECT * FROM DEPOSIT FETCH FIRST 5 ROWS ONLY"; break; case 1: sQuery1 = "SELECT * FROM LOAN FETCH FIRST 5 ROWS ONLY"; break; } using (IBM.Data.DB2.DB2Command cmd = new IBM.Data.DB2.DB2Command(sQuery1, conn)) { IBM.Data.DB2.DB2DataReader dr = cmd.ExecuteReader(); dt.Load(dr); } conn.Close(); if (dt.Rows.Count <= 0) { message = "No Record Exist !!!"; } else { SaveData(dt); message = "Successfully Imported '" + cmbTransactionType.Text + "' Data !!!"; } } catch (Exception ex) { message = ex.Message; } MessageBox.Show(message, "Import from DB2 Utility", MessageBoxButtons.OK, MessageBoxIcon.Information); }
public void Close() { if (_DB2Conn == null) { return; } try { _DB2Conn.Close(); _DB2Conn.Dispose(); _DB2Conn = null; } catch (System.Exception ex) { _DB2Conn = null; throw ex; } }
/* * Método que trae las posiciones que dispone cada part number. */ private static DataTable bringResultsForPositions(string toolIdToSearch, string _ProductPartNumberId) { IBM.Data.DB2.DB2Connection conn = null; DataTable dt = new DataTable("Table1"); conn = ConnectDb(); string queryDbGetRequestedDataForPositions = @" SELECT CGSLSC.TOOL_SETUP.*, TOOL_KEY AS EXPR1, PRODUCT_PN_KEY AS EXPR2 FROM CGSLSC.TOOL_SETUP WHERE (TOOL_KEY = " + toolIdToSearch + ") AND (PRODUCT_PN_KEY = " + _ProductPartNumberId + ")"; using (IBM.Data.DB2.DB2Command cmd = new IBM.Data.DB2.DB2Command(queryDbGetRequestedDataForPositions, conn)) { IBM.Data.DB2.DB2DataReader dr = cmd.ExecuteReader(); dt.Load(dr); } conn.Close(); return(dt); }
/* * Método que devuelve el nombre del part number ID */ private static DataTable bringResultsForProductPN(string _ProductPartNumberId) { IBM.Data.DB2.DB2Connection conn = null; DataTable dt = new DataTable("Table1"); conn = ConnectDb(); string queryDbGetRequestedDataForPN = @" SELECT PART_NUMBER_KEY AS EXPR1, CGS.PART_NUMBER.* FROM CGS.PART_NUMBER WHERE (PART_NUMBER_KEY = " + _ProductPartNumberId + ")"; using (IBM.Data.DB2.DB2Command cmd = new IBM.Data.DB2.DB2Command(queryDbGetRequestedDataForPN, conn)) { IBM.Data.DB2.DB2DataReader dr = cmd.ExecuteReader(); dt.Load(dr); } conn.Close(); return(dt); }
/* * Método que trae todos los datos de la tabla TOOL_SETUP_INFO por toolId */ private static DataTable bringResultsForToolId(string toolIdToSearch) { IBM.Data.DB2.DB2Connection conn = null; DataTable dt = new DataTable("Table1"); conn = ConnectDb(); string queryDbGetRequestedDataForToolKey = @"SELECT TS_INFO_KEY, PRODUCT_PN_KEY, TOOL_KEY, ROUTE_STEP_KEY, LAST_CHANGE_TMST, RECIPE_READY, RECIPE_ID, PROGRAM_ID, CARRIER_PN_KEY, DUAL_SIDED, DUAL_LANE, PFC_MODE, LAST_SETUP_TOOL_KEY, LAST_SETUP_TOOL_STAGE FROM CGSLSC.TOOL_SETUP_INFO WHERE (TOOL_KEY = " + toolIdToSearch + ") ORDER BY LAST_CHANGE_TMST DESC"; using (IBM.Data.DB2.DB2Command cmd = new IBM.Data.DB2.DB2Command(queryDbGetRequestedDataForToolKey, conn)) { IBM.Data.DB2.DB2DataReader dr = cmd.ExecuteReader(); dt.Load(dr); } conn.Close(); return(dt); }