/// <summary> /// Creates skeletal source code (without correct data structure but no business logic) for all /// data types found in the normative database. For versions > 2.2, Primitive data types are not /// generated, because they are coded manually (as of HAPI 0.3). /// </summary> /// /// <param name="baseDirectory"> Pathname of the base directory. </param> /// <param name="version"> the HL7 version of the intended data type. </param> public static void makeAll(System.String baseDirectory, System.String version) { //make base directory if (!(baseDirectory.EndsWith("\\") || baseDirectory.EndsWith("/"))) { baseDirectory = baseDirectory + "/"; } System.IO.FileInfo targetDir = SourceGenerator.makeDirectory( baseDirectory + PackageManager.GetVersionPackagePath(version) + "Datatype"); SourceGenerator.makeDirectory(baseDirectory + PackageManager.GetVersionPackagePath(version) + "Datatype"); //get list of data types System.Collections.ArrayList types = new System.Collections.ArrayList(); System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection; System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn); //get normal data types ... System.Data.OleDb.OleDbCommand temp_OleDbCommand; temp_OleDbCommand = stmt; temp_OleDbCommand.CommandText = "select data_type_code from HL7DataTypes, HL7Versions where HL7Versions.version_id = HL7DataTypes.version_id and HL7Versions.hl7_version = '" + version + "'"; System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader(); while (rs.Read()) { types.Add(System.Convert.ToString(rs[1 - 1])); } rs.Close(); //get CF, CK, CM, CN, CQ sub-types ... System.Data.OleDb.OleDbCommand temp_OleDbCommand2; temp_OleDbCommand2 = stmt; temp_OleDbCommand2.CommandText = "select data_structure from HL7DataStructures, HL7Versions where (" + "data_type_code = 'CF' or " + "data_type_code = 'CK' or " + "data_type_code = 'CM' or " + "data_type_code = 'CN' or " + "data_type_code = 'CQ') and " + "HL7Versions.version_id = HL7DataStructures.version_id and HL7Versions.hl7_version = '" + version + "'"; rs = temp_OleDbCommand2.ExecuteReader(); while (rs.Read()) { types.Add(System.Convert.ToString(rs[1 - 1])); } stmt.Dispose(); NormativeDatabase.Instance.returnConnection(conn); System.Console.Out.WriteLine("Generating " + types.Count + " datatypes for version " + version); if (types.Count == 0) { log.Warn("No version " + version + " data types found in database " + conn.Database); } for (int i = 0; i < types.Count; i++) { if (!((String)types[i]).Equals("*")) { make(targetDir, (System.String)types[i], version); } } }
private double soluongton(string mshs) { double kq = 0, kq1 = 0, kq2 = 0; try { string sql1 = "Select ntan From baoan where Month(ntan) = '" + (double.Parse(cboThang.Text) - 1) + "' and mshs = '" + mshs + "' and BS = 1"; System.Data.OleDb.OleDbDataReader dr1 = KPBT.Modules.Connect.TruyVandr(sql1); while (dr1.Read()) { kq1 += 1; } dr1.Close(); string sql2 = "Select sophaithu From thutien inner join dmthu on thutien.makhthu = dmthu.makhthu where thang = " + (double.Parse(cboThang.Text) - 1) + " and thutien.mshs = '" + mshs + "' and dmthu.tenkhoanthu = 'Tiền ăn'"; System.Data.OleDb.OleDbDataReader dr2 = KPBT.Modules.Connect.TruyVandr(sql2); while (dr2.Read()) { kq2 += double.Parse(dr2["sophaithu"].ToString()); } dr2.Close(); kq = kq2 - kq1; } catch { } return(kq); }
private void button1_Click(object sender, EventArgs e) { //Mostrar na listBox2 os alunos do curso selecionado no listBox1: try { listBox2.Items.Clear(); //limpamos a segunda lista string cursoSelec = (string)((DataRowView)listBox1.SelectedItem)[0]; string sql = "SELECT * FROM Alunos WHERE abrevcurso = '" + cursoSelec + "'"; //suponhamos o BD em C:\tempo System.Data.OleDb.OleDbConnection conexao = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/temp/Universidade3.mdb"); conexao.Open(); System.Data.OleDb.OleDbCommand comando = new System.Data.OleDb.OleDbCommand(sql, conexao); System.Data.OleDb.OleDbDataReader dr = comando.ExecuteReader(); while (dr.Read()) { string dadosAluno = dr.GetString(0) + ", " + dr.GetString(1) + ", " + dr.GetString(2) + ", " + dr.GetInt32(3) + ", " + dr.GetString(4); listBox2.Items.Add(dadosAluno); } dr.Close(); comando.Dispose(); conexao.Close(); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void button3_Click(object sender, EventArgs e) { // Botão btnResultados try { string id1 = txtIdade1.Text; string id2 = txtIdade2.Text; string strSsexo = ""; if (rbMasculino.Checked) strSsexo = " sexo = 'M' AND "; else if (rbFeminino.Checked) strSsexo = " sexo = 'F' AND "; else strSsexo = ""; sql = "select * from alunos WHERE " + strSsexo + " idade>=" + id1 + " AND idade<=" + id2 + " ORDER BY nome"; stm = new System.Data.OleDb.OleDbCommand(sql, conexao); rs = stm.ExecuteReader(); string strSaida = ""; while (rs.Read()) { string dados = "RGM: " + rs.GetString(0) + ", " + rs.GetString(1) + ", idade: " + rs.GetInt32(3) + ", sexo: " + rs.GetString(4) + ", curso: " + rs.GetString(2); strSaida += dados + "\r\n"; } txtResultados.Text = strSaida; } catch (Exception exsql) { MessageBox.Show("Erro na consulta"); } if(stm!=null)stm.Dispose(); if(rs!=null)rs.Close(); }
private void m_axCalendar_DoReadRPattern(object sender, AxXtremeCalendarControl._DCalendarControlEvents_DoReadRPatternEvent e) { if (!IsOpen()) { return; } System.Data.OleDb.OleDbDataReader oleReader = null; try { System.Data.OleDb.OleDbCommand oleDbCommand = m_oleDbConnection.CreateCommand(); oleDbCommand.CommandText = "SELECT * FROM CalendarRecurrencePatterns WHERE RecurrencePatternID = " + Convert.ToString(e.patternID); oleReader = oleDbCommand.ExecuteReader(); if (oleReader.Read()) { e.pPattern = m_DataHelper.CreateRPatternFromData(oleReader, m_oleDbConnection); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine("EXCEPTION! providerSQLServer.m_axCalendar_DoReadRPattern: " + ex.Message); } //================================================ if (oleReader != null && !oleReader.IsClosed) { oleReader.Close(); } }
/// <summary> Creates and writes source code for all Messages and Groups. </summary> /// /// <param name="baseDirectory"> Pathname of the base directory. </param> /// <param name="version"> The version. </param> public static void makeAll(System.String baseDirectory, System.String version) { //get list of messages ... using (System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection) { System.String sql = getMessageListQuery(version); System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn); System.Data.OleDb.OleDbCommand temp_OleDbCommand; temp_OleDbCommand = stmt; temp_OleDbCommand.CommandText = sql; System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader(); System.Collections.ArrayList messages = new System.Collections.ArrayList(); System.Collections.ArrayList chapters = new System.Collections.ArrayList(); while (rs.Read()) { messages.Add(System.Convert.ToString(rs[1 - 1])); chapters.Add(System.Convert.ToString(rs[2 - 1])); } rs.Close(); NormativeDatabase.Instance.returnConnection(conn); if (messages.Count == 0) { log.Warn("No version " + version + " messages found in database " + conn.Database); } for (int i = 0; i < messages.Count; i++) { make((System.String)messages[i], baseDirectory, (System.String)chapters[i], version); } } }
public static string FetchGivenNamefromExcel(string TestName) { DirectoryInfo currentDir = new DirectoryInfo(Directory.GetCurrentDirectory()); path = Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location).Replace("\\bin\\Debug", "") + "\\Input Files\\TestData.xlsx"; System.Data.OleDb.OleDbConnection MyConnection; string sqlTest = null; MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + path + "'; Extended Properties='Excel 12.0; HDR = YES'"); MyConnection.Open(); sqlTest = "select * from [" + ObjectRepository.ProjectName + "$] where TestCasesName =\"" + TestName + "\""; System.Data.OleDb.OleDbCommand TestCommand = new System.Data.OleDb.OleDbCommand(sqlTest, MyConnection); System.Data.OleDb.OleDbDataReader TestReader = TestCommand.ExecuteReader(); GetGivenName = new Dictionary <int, string>(); while (TestReader.Read()) { int i = 1; for (int Row = 1; Row < TestReader.FieldCount; Row++) { GetGivenName.Add(i, TestReader.GetValue(Row).ToString().Trim()); i++; } } TestReader.Close(); return(GetGivenName[2].ToString()); }
/// <summary> Fetches the last modification time of the resource /// * /// </summary> /// <param name="resource">Resource object we are finding timestamp of /// </param> /// <param name="i_operation">string for logging, indicating caller's intention /// * /// </param> /// <returns>timestamp as long /// /// </returns> private long readLastModified(Resource resource, System.String i_operation) { /* * get the template name from the resource */ System.String name = resource.Name; try { System.Data.OleDb.OleDbConnection conn = openDbConnection(); try { //UPGRADE_TODO: The equivalent of java.sql.ResultSet must call Close() before performing any other operation with the associated connection. 'ms-help://MS.VSCC/commoner/redir/redirect.htm?keyword="jlca1129"' System.Data.OleDb.OleDbDataReader rs = readData(conn, timestampColumn, name); try { if (rs.Read()) { return((System.Convert.ToDateTime(rs[(timestampColumn)]).Ticks - 621355968000000000) / 10000); } else { System.Diagnostics.Process.error("DataSourceResourceLoader Error: while " + i_operation + " could not find resource " + name); } } finally { rs.Close(); } } finally { closeDbConnection(conn); } } catch (System.Exception e) { System.Diagnostics.Process.error("DataSourceResourceLoader Error: error while " + i_operation + " when trying to load resource " + name + ": " + e.ToString()); } return(0); }
/// <summary> <p>Creates skeletal source code (without correct data structure but no business /// logic) for all data types found in the normative database. For versions > 2.2, Primitive data types /// are not generated, because they are coded manually (as of HAPI 0.3). /// </summary> public static void makeAll(System.String baseDirectory, System.String version) { //make base directory if (!(baseDirectory.EndsWith("\\") || baseDirectory.EndsWith("/"))) { baseDirectory = baseDirectory + "/"; } System.IO.FileInfo targetDir = SourceGenerator.makeDirectory(baseDirectory + SourceGenerator.getVersionPackageDirectory(version) + "datatype"); SourceGenerator.makeDirectory(baseDirectory + SourceGenerator.getVersionPackageDirectory(version) + "datatype"); //get list of data types System.Collections.ArrayList types = new System.Collections.ArrayList(); //UPGRADE_NOTE: There are other database providers or managers under System.Data namespace which can be used optionally to better fit the application requirements. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1208'" System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection; //UPGRADE_TODO: Method 'java.sql.Connection.createStatement' was converted to 'SupportClass.TransactionManager.manager.CreateStatement' which has a different behavior. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1073_javasqlConnectioncreateStatement'" System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn); //get normal data types ... //UPGRADE_TODO: Interface 'java.sql.ResultSet' was converted to 'System.Data.OleDb.OleDbDataReader' which has a different behavior. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1073_javasqlResultSet'" System.Data.OleDb.OleDbCommand temp_OleDbCommand; temp_OleDbCommand = stmt; temp_OleDbCommand.CommandText = "select data_type_code from HL7DataTypes, HL7Versions where HL7Versions.version_id = HL7DataTypes.version_id and HL7Versions.hl7_version = '" + version + "'"; System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader(); while (rs.Read()) { types.Add(System.Convert.ToString(rs[1 - 1])); } rs.Close(); //get CF, CK, CM, CN, CQ sub-types ... System.Data.OleDb.OleDbCommand temp_OleDbCommand2; temp_OleDbCommand2 = stmt; temp_OleDbCommand2.CommandText = "select data_structure from HL7DataStructures, HL7Versions where (" + "data_type_code = 'CF' or " + "data_type_code = 'CK' or " + "data_type_code = 'CM' or " + "data_type_code = 'CN' or " + "data_type_code = 'CQ') and " + "HL7Versions.version_id = HL7DataStructures.version_id and HL7Versions.hl7_version = '" + version + "'"; rs = temp_OleDbCommand2.ExecuteReader(); while (rs.Read()) { types.Add(System.Convert.ToString(rs[1 - 1])); } //UPGRADE_ISSUE: Method 'java.sql.Statement.close' was not converted. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1000_javasqlStatementclose'" stmt.Dispose(); NormativeDatabase.Instance.returnConnection(conn); System.Console.Out.WriteLine("Generating " + types.Count + " datatypes for version " + version); if (types.Count == 0) { //UPGRADE_ISSUE: Method 'java.lang.System.getProperty' was not converted. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1000_javalangSystem'" log.warn("No version " + version + " data types found in database " + conn.Database); } for (int i = 0; i < types.Count; i++) { if (!((String)types[i]).Equals("*")) { make(targetDir, (System.String)types[i], version); } } }
private void createAndFillRegenRef() { using (System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(dbLc)) { con.Open(); //Console.WriteLine("opened the database"); string sql = "SELECT PLT_CN, SUBP, SPCD, TREECOUNT FROM SEEDLING"; System.Data.OleDb.OleDbCommand oleCom = new System.Data.OleDb.OleDbCommand(sql, con); System.Data.OleDb.OleDbDataReader oleRd = oleCom.ExecuteReader(); while (oleRd.Read()) { object[] vls = new object[4]; oleRd.GetValues(vls); string pltCn = vls[0].ToString(); string subp = vls[1].ToString(); if (SubPlotField == "" || SubPlotField == null) { subp = "0"; } string linkVl = pltCn + "_" + subp; //Console.WriteLine("Link = " + linkVl.ToString()); if (unPlots.Contains(linkVl)) { string spcd = vls[2].ToString(); string stcd = "1"; string grpCd = spcd; if (groupstatuscode) { grpCd = spcd + "_" + stcd; } if (grp) { spcd = findGrp(grpCd); } rUnSp.Add(spcd); int tCnt = System.Convert.ToInt32(vls[3]); string lk = linkVl + "_" + spcd.ToString(); int vlOut; if (rgDic.TryGetValue(lk, out vlOut)) { rgDic[lk] = vlOut + tCnt; } else { rgDic.Add(lk, tCnt); } } } oleRd.Close(); con.Close(); } }
/// <summary> /// 查询协议标识字典 /// </summary> /// <param name="sql">查询语句</param> /// <param name="AccessPath">Access数据库路径</param> /// <param name="Ip">服务器数据库Ip地址</param> /// <param name="UserName">服务器登录名</param> /// <param name="pwd">密码</param> /// <returns></returns> private DgnProtocolInfo GetProDLT645Dict(string sql, string AccessPath, string Ip, string UserName, string pwd) { DgnProtocolInfo Items = new DgnProtocolInfo(); bool flag = false; if (Ip != "") { flag = ConnectDataBase("", Ip, UserName, pwd); } else if (AccessPath != "") { flag = ConnectDataBase(AccessPath, "", "", ""); } else { flag = ConnectDataBase("", "", "", ""); } try { if (!flag) { return(Items); } System.Data.OleDb.OleDbCommand Cmd = new System.Data.OleDb.OleDbCommand(sql, _Data.Con); System.Data.OleDb.OleDbDataReader Reader = Cmd.ExecuteReader(); while (Reader.Read()) { Items.Pd_dltID = Convert.ToInt32(Reader["dltID"].ToString()); //编号 Items.Pd_proNameNo = Convert.ToInt32(Reader["proNameNo"].ToString()); //国标协议代号 Items.Pd_intIdentType = Convert.ToInt32(Reader["intIdentType"].ToString()); //数据标识编码类型 Items.Pd_intClass = Convert.ToInt32(Reader["intClass"].ToString()); //权限 Items.Pd_chrItemName = Reader["chrItemName"].ToString(); //项目名称 Items.Pd_chrID = Reader["chrID"].ToString(); //数据标识 Items.Pd_intLength = Convert.ToInt32(Reader["intLength"].ToString()); //长度 Items.Pd_intDot = Convert.ToInt32(Reader["intDot"].ToString()); //小数位 Items.Pd_chrFormat = Reader["chrFormat"].ToString(); //格式串 Items.Pd_intType = Convert.ToInt32(Reader["intType"].ToString()); //操作方式 Items.Pd_chrDefValue = Reader["chrDefValue"].ToString(); //定义值 } Reader.Close(); } catch (Exception e) { System.Windows.Forms.MessageBox.Show(e.Message, "数据库操作错误", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); } finally { _Data.CloseDB(); } return(Items); }
private double sotien() { double kq = 0; string sql = "Select sotien/soluong as tien From dmthu where tenkhoanthu = 'Tiền ăn'"; System.Data.OleDb.OleDbDataReader dr = KPBT.Modules.Connect.TruyVandr(sql); while (dr.Read()) { kq = classdc.dungchung.kieudouble(dr["tien"].ToString()); } dr.Close(); return(kq); }
private string ho(string mshs) { string kq = ""; sql = "Select tenhs From hocsinh where mshs = '" + mshs + "'"; System.Data.OleDb.OleDbDataReader dr = KPBT.Modules.Connect.TruyVandr(sql); while (dr.Read()) { kq = dr["tenhs"].ToString().Substring(0, dr["tenhs"].ToString().LastIndexOf(" ")); } dr.Close(); return(kq); }
//public string getEmail() //{ // return loggedEmail; //} internal bool Login(string email, string password) { System.Data.OleDb.OleDbCommand comm = new System.Data.OleDb.OleDbCommand(); comm.CommandType = System.Data.CommandType.Text; comm.CommandText = "SELECT [Email], [Password] FROM USERS\nWHERE [Email] = \'" + email + "\' AND [Password] = \'" + password + "\';"; comm.Connection = conn; conn.Open(); System.Data.OleDb.OleDbDataReader result = null; try { //comm.Connection.Open(); result = comm.ExecuteReader(); //MessageBox.Show((string)returnValue); } catch (Exception e) { conn.Close(); MessageBox.Show(e.Message); } //MessageBox.Show("Reader:" + result.ToString()+"\n"+result[0]); if (result.HasRows) { //LOG THE F**K IN conn.Close(); result.Close(); loggedEmail = email; return(true); } else { MessageBox.Show("Email and/or password are invalid ¯\\_(ツ)_/¯"); } conn.Close(); result.Close(); return(false); //throw new NotImplementedException(); }
private string kt(string ngaydanhgia, string lop) { string kq = ""; string sql = "Select theodoisk.ngaydanhgia,hocsinh.tenphong" + " From theodoisk inner join hocsinh on theodoisk.mahocsinh = hocsinh.mshs" + " where theodoisk.ngaydanhgia = #" + classdc.dungchung.thaydoi(ngaydanhgia) + "# and hocsinh.tenphong = '" + lop + "'"; System.Data.OleDb.OleDbDataReader dr = KPBT.Modules.Connect.TruyVandr(sql); while (dr.Read()) { kq = "C"; } dr.Close(); return(kq); }
private void updateSpeciesFromTreeTable() { fieldSpcd.Clear(); using (System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(dbLc)) { con.Open(); string sql = "SELECT DISTINCT PLT_CN, SPCD FROM TREE WHERE DIA >= 5 and SPCD > 0"; if (lt5) { sql = "SELECT DISTINCT PLT_CN, SPCD FROM TREE WHERE SPCD > 0"; } System.Data.OleDb.OleDbCommand oleCom = new System.Data.OleDb.OleDbCommand(sql, con); System.Data.OleDb.OleDbDataReader oleRd = oleCom.ExecuteReader(); while (oleRd.Read()) { object[] vls = new object[2]; oleRd.GetValues(vls); string pcn = vls[0].ToString().ToUpper(); if (fieldPltCn.Contains(pcn)) { string spcd = vls[1].ToString(); fieldSpcd.Add(spcd); } } oleRd.Close(); if (seedlings) { sql = "SELECT DISTINCT PLT_CN, SPCD FROM SEEDLING"; oleCom.CommandText = sql; oleRd = oleCom.ExecuteReader(); while (oleRd.Read()) { object[] vls = new object[2]; oleRd.GetValues(vls); string pcn = vls[0].ToString().ToUpper(); if (fieldPltCn.Contains(pcn)) { string spcd = vls[1].ToString(); fieldSpcd.Add(spcd); } } } con.Close(); } populateSpeciesList(); populateDataTable(); }
private void pmCal1() { //conn = new System.Data.OleDb.OleDbConnection(App.ConnectionString); //conn2 = new System.Data.OleDb.OleDbConnection(App.ConnectionString); //conn.Open(); //conn2.Open(); //pmCal1(); //conn.Close(); //conn2.Close(); //conn.Dispose(); //conn2.Dispose(); System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("select * from EMPROJ where CCORP = ? and CTYPE = 'G' and CCODE between ? and ? and CPRPROJ = '' ", conn); cmd.Parameters.AddWithValue("@P1", App.ActiveCorp.RowID); cmd.Parameters.AddWithValue("@P2", this.txtBegQcProj1.Text.Trim()); cmd.Parameters.AddWithValue("@P3", this.txtEndQcProj1.Text.Trim()); System.Data.OleDb.OleDbCommand cmd2 = new System.Data.OleDb.OleDbCommand("select * from EMPROJ where CPRPROJ = ? ", conn); cmd2.Parameters.AddWithValue("@P1", ""); System.Data.OleDb.OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { DataRow dtrPLine = this.dtsDataEnv.Tables[this.mstrTemBg].NewRow(); dtrPLine["cQcProj"] = dr["cCode"].ToString().TrimEnd(); dtrPLine["cQnProj"] = dr["cName"].ToString().TrimEnd(); this.dtsDataEnv.Tables[this.mstrTemBg].Rows.Add(dtrPLine); //cmd2.Parameters.Clear(); cmd2.Parameters["@P1"].Value = dr["cRowID"].ToString(); System.Data.OleDb.OleDbDataReader dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { DataRow dtrPLine2 = this.dtsDataEnv.Tables[this.mstrTemBg].NewRow(); dtrPLine2["cQcProj"] = dr2["cCode"].ToString().TrimEnd(); dtrPLine2["cQnProj"] = dr2["cName"].ToString().TrimEnd(); this.dtsDataEnv.Tables[this.mstrTemBg].Rows.Add(dtrPLine2); } dr2.Close(); } dr.Close(); cmd2.Dispose(); cmd.Dispose(); }
private void m_axCalendar_DoCreateRPattern(object sender, AxXtremeCalendarControl._DCalendarControlEvents_DoCreateRPatternEvent e) { e.bResult = false; if (!IsOpen()) { return; } try { String strSQL = "SELECT * FROM CalendarRecurrencePatterns WHERE RecurrencePatternID = 0 "; System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter(strSQL, m_oleDbConnection); System.Data.OleDb.OleDbCommandBuilder custCB = new System.Data.OleDb.OleDbCommandBuilder(oleDbDataAdapter); custCB.QuotePrefix = "["; custCB.QuoteSuffix = "]"; System.Data.DataSet objPatternDSet = new System.Data.DataSet(); oleDbDataAdapter.Fill(objPatternDSet); //code to modify data in dataset here System.Data.DataRow objDRow = objPatternDSet.Tables[0].NewRow(); objPatternDSet.Tables[0].Rows.Add(objDRow); m_DataHelper.PutRPatternToData(e.pPattern, objDRow); oleDbDataAdapter.Update(objPatternDSet); //'-- update Auto EventID System.Data.OleDb.OleDbCommand objCommand = m_oleDbConnection.CreateCommand(); objCommand.CommandText = "SELECT MAX(RecurrencePatternID) AS NewNewPatternID FROM CalendarRecurrencePatterns"; System.Data.OleDb.OleDbDataReader objReader = objCommand.ExecuteReader(); objReader.Read(); e.newPatternID = objReader.GetInt32(0); objReader.Close(); e.bResult = true; } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine("EXCEPTION! providerSQLServer.m_axCalendar_DoCreateRPattern: " + ex.Message); } }
/// <summary> /// 查询通讯协议 /// </summary> /// <param name="sql">查询语句</param> /// <param name="AccessPath">Access数据库路径</param> /// <param name="Ip">服务器数据库Ip地址</param> /// <param name="UserName">服务器登录名</param> /// <param name="pwd">密码</param> /// <returns></returns> private DgnProtocolInfo GetProtocolInfo(string sql, string AccessPath, string Ip, string UserName, string pwd) { DgnProtocolInfo Items = new DgnProtocolInfo(); bool flag = false; if (Ip != "") { flag = ConnectDataBase("", Ip, UserName, pwd); } else if (AccessPath != "") { flag = ConnectDataBase(AccessPath, "", "", ""); } else { flag = ConnectDataBase("", "", "", ""); } try { if (!flag) { return(Items); } System.Data.OleDb.OleDbCommand Cmd = new System.Data.OleDb.OleDbCommand(sql, _Data.Con); System.Data.OleDb.OleDbDataReader Reader = Cmd.ExecuteReader(); while (Reader.Read()) { Items.Pro_ProtocolID = Convert.ToInt32(Reader["ProtocolID"].ToString()); //协议编号 Items.Pro_proNameNo = Convert.ToInt32(Reader["proNameNo"].ToString()); //通讯协议归属 Items.Pro_chrPname = Reader["chrPname"].ToString(); //协议名称 Items.Pro_intInfoNo = Convert.ToInt32(Reader["intInfoNo"].ToString()); //信息序号 Items.Pro_chrValue = Reader["chrValue"].ToString(); //对应值 } Reader.Close(); } catch (Exception e) { System.Windows.Forms.MessageBox.Show(e.Message, "数据库操作错误", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); } finally { _Data.CloseDB(); } return(Items); }
private void button3_Click(object sender, EventArgs e) { // Botão btnResultados try { string id1 = txtIdade1.Text; string id2 = txtIdade2.Text; string strSsexo = ""; if (rbMasculino.Checked) { strSsexo = " sexo = 'M' AND "; } else if (rbFeminino.Checked) { strSsexo = " sexo = 'F' AND "; } else { strSsexo = ""; } sql = "select * from alunos WHERE " + strSsexo + " idade>=" + id1 + " AND idade<=" + id2 + " ORDER BY nome"; stm = new System.Data.OleDb.OleDbCommand(sql, conexao); rs = stm.ExecuteReader(); string strSaida = ""; while (rs.Read()) { string dados = "RGM: " + rs.GetString(0) + ", " + rs.GetString(1) + ", idade: " + rs.GetInt32(3) + ", sexo: " + rs.GetString(4) + ", curso: " + rs.GetString(2); strSaida += dados + "\r\n"; } txtResultados.Text = strSaida; } catch (Exception exsql) { MessageBox.Show("Erro na consulta"); } if (stm != null) { stm.Dispose(); } if (rs != null) { rs.Close(); } }
/// <summary> /// xls文件转数据表 /// </summary> /// <param name="fileName">文件名</param> /// <returns></returns> public static System.Data.DataTable XlsToData(string fileName) { string fileExtenSion; fileExtenSion = System.IO.Path.GetExtension(fileName); if (fileExtenSion.ToLower() != ".xls" && fileExtenSion.ToLower() != ".xlsx") { return null; } System.Data.OleDb.OleDbConnection conn = null; try { //HDR=Yes,这代表第一行是标题,不做为数据使用 ,如果用HDR=NO,则表示第一行不是标题,做为数据来使用。系统默认的是YES string connstr2003 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'"; string connstr2007 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=\"Excel 12.0;HDR=YES\""; if (fileExtenSion.ToLower() == ".xls") { conn = new System.Data.OleDb.OleDbConnection(connstr2003); } else { conn = new System.Data.OleDb.OleDbConnection(connstr2007); } conn.Open(); string sql = "select * from [Sheet1$]"; System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(sql, conn); System.Data.DataTable dt = new System.Data.DataTable(); System.Data.OleDb.OleDbDataReader sdr = cmd.ExecuteReader(); dt.Load(sdr); sdr.Close(); conn.Close(); return dt; } catch { return null; } finally { if (conn != null) conn.Close(); } }
private void ReportFooter_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { double kq = 0; System.Data.OleDb.OleDbDataReader dr = KPBT.Modules.Connect.TruyVandr("Select distinct TEN1 From TblDC"); if (dr != null) { while (dr.Read()) { kq += 1; } dr.Close(); } if (kq == 1) { xrTblTC.Visible = false; } }
public override void Render(Pink.Request req, object o) { req.WriteString("<!DOCTYPE html>\r\n<html>\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<title>Blog Index</title" + ">\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/css/style.css\">\r\n</head>\r\n<body" + ">\r\n<img src=\"/img/pinkserver.png\" style=\"text-align: center;\">\r\n<h1>Pink Server " + "Blog</h1>\r\n<i>"); req.WriteString(string.Format("{0}", DateTime.Now)); req.WriteString("</i>\r\n<p>This the front page of the Pink Blog.</p>\r\n<table>\r\n"); System.Data.OleDb.OleDbDataReader reader = Blog.DB.Query("SELECT ID, Title, Author, Date FROM Pages;", 10);; req.WriteString("\r\n<tr>\r\n "); for (int i = 0; i < reader.FieldCount; i++) { ; req.WriteString(" \r\n <th> "); req.WriteString(string.Format("{0}", reader.GetName(i))); req.WriteString(" </th>\r\n "); } ; req.WriteString("\r\n <th>link</th>\r\n</tr>\r\n"); while (reader.Read()) { ; req.WriteString("\r\n<tr>\r\n "); for (int i = 0; i < reader.FieldCount; i++) { ; req.WriteString("\r\n <td> "); req.WriteString(string.Format("{0}", reader[i])); req.WriteString(" </td>\r\n "); } ; req.WriteString("\r\n <td><a href=\"/article/"); req.WriteString(string.Format("{0}", reader[0])); req.WriteString("\">"); req.WriteString(string.Format("{0}", reader[1])); req.WriteString("</a></td>\r\n</tr>\r\n"); } reader.Close();; req.WriteString("\r\n</table>\r\n<p><a href=\"/editor/-1\">new article</a></p>\r\n<p>"); req.WriteString(string.Format("{0}", req.Method)); req.WriteString("</p>\r\n<p>"); req.WriteString(string.Format("{0}", req.URL)); req.WriteString("</p>\r\n</body>\r\n</html>"); }
protected void ReadRPatternExceptions(CalendarRecurrencePattern pPattern, System.Data.OleDb.OleDbConnection pOleDbConn) { if (pPattern == null || pOleDbConn == null) { System.Diagnostics.Debug.Assert(false); return; } System.Data.OleDb.OleDbDataReader oleReader = null; try { int nPatternID = pPattern.Id; String strSQL = "SELECT * FROM CalendarEvents WHERE \r\n"; strSQL += " RecurrenceState = " + Convert.ToString((int)CalendarEventRecurrenceState.xtpCalendarRecurrenceException); strSQL += " AND RecurrencePatternID = " + Convert.ToString(nPatternID); System.Data.OleDb.OleDbCommand oleDbCommand = pOleDbConn.CreateCommand(); oleDbCommand.CommandText = strSQL; oleReader = oleDbCommand.ExecuteReader(); while (oleReader.Read()) { CalendarEvent axEvent = _CreateEventFromData(oleReader, true); if (axEvent != null) { pPattern.SetException(axEvent); } } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine("EXCEPTION! SQLDataHelper.ReadRPatternExceptions: " + ex.Message); } //================================================ if (oleReader != null && !oleReader.IsClosed) { oleReader.Close(); } }
/// <summary> Get an InputStream so that the Runtime can build a /// template with it. /// * /// </summary> /// <param name="name">name of template /// </param> /// <returns>InputStream containing template /// /// </returns> //UPGRADE_NOTE: Synchronized keyword was removed from method 'getResourceStream'. Lock expression was added. 'ms-help://MS.VSCC/commoner/redir/redirect.htm?keyword="jlca1027"' public override System.IO.Stream getResourceStream(System.String name) { lock (this) { if (name == null || name.Length == 0) { throw new ResourceNotFoundException("Need to specify a template name!"); } try { System.Data.OleDb.OleDbConnection conn = openDbConnection(); try { //UPGRADE_TODO: The equivalent of java.sql.ResultSet must call Close() before performing any other operation with the associated connection. 'ms-help://MS.VSCC/commoner/redir/redirect.htm?keyword="jlca1129"' System.Data.OleDb.OleDbDataReader rs = readData(conn, templateColumn, name); try { if (rs.Read()) { //UPGRADE_ISSUE: Method 'java.sql.ResultSet.getAsciiStream' was not converted. 'ms-help://MS.VSCC/commoner/redir/redirect.htm?keyword="jlca1000_javasqlResultSetgetAsciiStream_javalangString"' return(new System.IO.BufferedStream(rs.getAsciiStream(templateColumn))); } else { System.String msg = "DataSourceResourceLoader Error: cannot find resource " + name; System.Diagnostics.Process.error(msg); throw new ResourceNotFoundException(msg); } } finally { rs.Close(); } } finally { closeDbConnection(conn); } } catch (System.Exception e) { System.String msg = "DataSourceResourceLoader Error: database problem trying to load resource " + name + ": " + e.ToString(); System.Diagnostics.Process.error(msg); throw new ResourceNotFoundException(msg); } } }
private void populateSpeciesDictionary() { int pltCnt = fieldPltCn.Count; using (System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(dbLc)) { con.Open(); string sql = "SELECT SPCD, COMMON_NAME FROM REF_SPECIES ORDER BY SPCD"; System.Data.OleDb.OleDbCommand oleCom = new System.Data.OleDb.OleDbCommand(sql, con); System.Data.OleDb.OleDbDataReader oleRd = oleCom.ExecuteReader(); while (oleRd.Read()) { object[] vls = new object[2]; oleRd.GetValues(vls); string jVl = vls[0].ToString() + " | " + vls[1].ToString(); spDic.Add(vls[0].ToString(), vls[1].ToString()); //lstSpecies.Items.Add(jVl); } oleRd.Close(); con.Close(); } }
private string[] getStatusCodes() { HashSet <string> statusCodeHash = new HashSet <string>(); using (System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(dbLc)) { con.Open(); string sql = "SELECT DISTINCT STATUSCD FROM TREE"; System.Data.OleDb.OleDbCommand oleCom = new System.Data.OleDb.OleDbCommand(sql, con); System.Data.OleDb.OleDbDataReader oleRd = oleCom.ExecuteReader(); while (oleRd.Read()) { object[] vls = new object[1]; oleRd.GetValues(vls); string spcd = vls[0].ToString(); statusCodeHash.Add(spcd); } oleRd.Close(); con.Close(); } return(statusCodeHash.ToArray()); }
/// <summary> /// Queries the normative database for a list of segments comprising the message structure. The /// returned list may also contain strings that denote repetition and optionality. Choice /// indicators (i.e. begin choice, next choice, end choice) for alternative segments are ignored, /// so that the class structure allows all choices. The matter of enforcing that only a single /// choice is populated can't be handled by the class structure, and should be handled elsewhere. /// </summary> /// /// <param name="message"> The message. </param> /// <param name="version"> The version. </param> /// /// <returns> An array of segment definition. </returns> private static SegmentDef[] getSegments(System.String message, System.String version) { /*String sql = "select HL7Segments.seg_code, repetitional, optional, description " + * "from (HL7MsgStructIDSegments inner join HL7Segments on HL7MsgStructIDSegments.seg_code = HL7Segments.seg_code " + * "and HL7MsgStructIDSegments.version_id = HL7Segments.version_id) " + * "where HL7Segments.version_id = 6 and message_structure = '" + message + "' order by seq_no";*/ System.String sql = getSegmentListQuery(message, version); //System.out.println(sql.toString()); SegmentDef[] segments = new SegmentDef[200]; //presumably there won't be more than 200 using (System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection) { System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn); System.Data.OleDb.OleDbCommand temp_OleDbCommand; temp_OleDbCommand = stmt; temp_OleDbCommand.CommandText = sql; System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader(); int c = -1; while (rs.Read()) { System.String name = SegmentGenerator.altSegName(System.Convert.ToString(rs[1 - 1])); bool repeating = rs.GetBoolean(2 - 1); bool optional = rs.GetBoolean(3 - 1); System.String desc = System.Convert.ToString(rs[4 - 1]); System.String groupName = System.Convert.ToString(rs[6 - 1]); //ignore the "choice" directives ... the message class structure has to include all choices ... // if this is enforced (i.e. exception thrown if >1 choice populated) this will have to be done separately. if (!(name.Equals("<") || name.Equals("|") || name.Equals(">"))) { c++; segments[c] = new SegmentDef(name, groupName, !optional, repeating, desc); } } rs.Close(); SegmentDef[] ret = new SegmentDef[c + 1]; Array.Copy(segments, 0, ret, 0, c + 1); return(ret); } }
protected IList <movimento> Read(int anno) { string query = "SELECT * from " + _tableName + " where anno = " + anno.ToString(); System.Data.OleDb.OleDbConnection c = new System.Data.OleDb.OleDbConnection(_connStringAccessDB); c.Open(); System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(query, c); System.Data.OleDb.OleDbDataReader r = cmd.ExecuteReader(); IList <movimento> movimenti = new List <movimento>(); while (r.Read()) { DoLoadMovimenti(r, movimenti); } r.Close(); c.Close(); return(movimenti); }
private string laydanhgia(string cannang, string gioitinh, string thangtuoi, string chieucao) { string kq = ""; System.Data.OleDb.OleDbDataReader dr = KPBT.Modules.Connect.TruyVandr("Select * From tblBMI "); while (dr.Read()) { if (gioitinh == dr["gioitinh"].ToString()) { if (double.Parse(thangtuoi) == double.Parse(dr["thang"].ToString())) { if (BMI(cannang, chieucao) <= double.Parse(dr["SD3duoi"].ToString())) { kq = "Rất gầy"; } if (BMI(cannang, chieucao) <= double.Parse(dr["SD2duoi"].ToString()) && BMI(cannang, chieucao) > double.Parse(dr["SD3duoi"].ToString())) { kq = "Gầy"; } if (BMI(cannang, chieucao) < double.Parse(dr["SD1tren"].ToString()) && BMI(cannang, chieucao) > double.Parse(dr["SD2duoi"].ToString())) { kq = "Bình thường"; } if (BMI(cannang, chieucao) < double.Parse(dr["SD2tren"].ToString()) && BMI(cannang, chieucao) >= double.Parse(dr["SD1tren"].ToString())) { kq = "Thừa cân"; } if (BMI(cannang, chieucao) >= double.Parse(dr["SD2tren"].ToString())) { kq = "Béo phì"; } } } } dr.Close(); return(kq); }
//================================================================== private void m_axCalendar_DoRetrieveDayEvents(object sender, AxXtremeCalendarControl._DCalendarControlEvents_DoRetrieveDayEventsEvent e) { if (!IsOpen()) { return; } System.Data.OleDb.OleDbDataReader oleReader = null; try { System.Data.OleDb.OleDbCommand oleDbCommand = m_oleDbConnection.CreateCommand(); oleDbCommand.CommandText = m_DataHelper.MakeRetrieveDayEventsSQL(e.dtDay); oleReader = oleDbCommand.ExecuteReader(); while (oleReader.Read()) { CalendarEvent axEvent = m_DataHelper.CreateEventFromData(oleReader); if (axEvent != null) { e.events.Add(axEvent); } } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine("EXCEPTION! providerSQLServer.m_axCalendar_DoRetrieveDayEvents: " + ex.Message); } //================================================ if (oleReader != null && !oleReader.IsClosed) { oleReader.Close(); } }
public byte[] GetLargeField(string strSql) { //string block="SELECT image from test_image WHERE id = 100";//INTO :b this.command.Connection = this.Conn as System.Data.OleDb.OleDbConnection; this.command.Transaction = Mder.FC.DB.DBTrans.Trans as System.Data.OleDb.OleDbTransaction; command.CommandText = strSql + ""; command.CommandType = System.Data.CommandType.Text; System.Data.OleDb.OleDbDataReader reader; command.Parameters.Clear(); try { reader = command.ExecuteReader(); } catch (System.Data.OleDb.OleDbException ex) { this.Err = "执行产生错误!" + ex.Message; this.ErrCode = strSql; this.DBErrCode = ex.ErrorCode; this.WriteErr(); return null; } catch (Exception ex) { this.Err = ex.Message; this.WriteErr(); return null; } reader.Read(); byte[] byteData = new byte[0]; try { byteData = (byte[])(reader[0]); } catch (Exception ex) { this.Err = ex.Message; reader.Close(); return null; } reader.Close(); return byteData; }