public override DataTable ExecuteQuery(string cmdText, DBHelperParmCollection parameters) { DataTable dtRet = new DataTable(); MySqlCommand _MySqlCommand = (MySqlCommand)CreateCommand(cmdText, CommandType.Text); _MySqlCommand.Parameters.Clear(); if (parameters != null) { foreach (DBHelperParm dbPara in parameters) { _MySqlCommand.Parameters.Add(new MySqlParameter("?" + dbPara.Key, dbPara.Value)); } } MySqlDataAdapter _MySqlDataAdapter = new MySqlDataAdapter(_MySqlCommand); try { _MySqlDataAdapter.Fill(dtRet); } catch (Exception ex) { throw ex; } return(dtRet); }
/// <summary> /// 执行存储过程,返回结果数据 /// </summary> /// <param name="procedureName">过程名</param> public override DataTable ExecuteProcedureQuery(string procedureName, DBHelperParmCollection parameters) { try { DataTable dtbRtn = new DataTable(); string realProcedureName = string.Format("{{CALL {0} (", procedureName); for (int i = 0; i < parameters.Count; i++) { realProcedureName += "?,"; } realProcedureName = realProcedureName.Substring(0, realProcedureName.Length - 1); realProcedureName += ")}"; OdbcCommand _OdbcCommand = (OdbcCommand)CreateCommand(realProcedureName, CommandType.StoredProcedure); if (parameters != null) { foreach (DBHelperParm para in parameters) { _IDbCommand.Parameters.Add(new OdbcParameter("?" + para.Key, para.Value)); } } OdbcDataAdapter _OdbcDataAdapter = new OdbcDataAdapter(_OdbcCommand); _OdbcDataAdapter.Fill(dtbRtn); return(dtbRtn); } catch (Exception ex) { throw ex; } }
public override DataTable ExecuteQuery(string cmdText, DBHelperParmCollection parameters) { DataTable dtRet = new DataTable(); AseCommand _AseCommand = (AseCommand)CreateCommand(cmdText, CommandType.Text); _AseCommand.Parameters.Clear(); if (parameters != null) { foreach (DBHelperParm para in parameters) { _AseCommand.Parameters.Add(new AseParameter("?" + para.Key, EncodingHelper.Default2DB(para.Value, _DBEncodeing))); } } AseDataAdapter _OdbcDataAdapter = new AseDataAdapter(_AseCommand); try { ProcessDataTable(dtRet); _OdbcDataAdapter.Fill(dtRet); } catch (Exception ex) { throw ex; } return(dtRet); }
public void Save() { DBHelperParmCollection param = new DBHelperParmCollection(); param.Add(new DBHelperParm("@UserName", "UserName")); param.Add(new DBHelperParm("@Password", "Password")); StringBuilder sbSql = new StringBuilder(""); try { sbSql.Append("INSERT INTO AMP_TEST (UserName,Password) "); sbSql.Append("VALUES (?,?)"); DBHelper.ExecuteNoQuery(sbSql.ToString(), param); } catch (Exception ex) { throw ex; } }
/// <summary> /// 执行存储过程 /// </summary> /// <param name="procedureName">过程名</param> /// <returns>返回执行正确的行数</returns> public override int ExecuteProcedureNoQuery(string procedureName, DBHelperParmCollection parameters) { int iRtn = -1; try { string realProcedureName = string.Format("{{CALL {0} (", procedureName); for (int i = 0; i < parameters.Count; i++) { realProcedureName += "?,"; } realProcedureName = realProcedureName.Substring(0, realProcedureName.Length - 1); realProcedureName += ")}"; OdbcCommand _OdbcCommand = (OdbcCommand)CreateCommand(realProcedureName, CommandType.StoredProcedure); if (parameters != null) { foreach (DBHelperParm para in parameters) { _OdbcCommand.Parameters.Add(new OdbcParameter("?" + para.Key, para.Value)); } } iRtn = _OdbcCommand.ExecuteNonQuery(); // 设置异常问题 if (iRtn == -1) { _ErrorMsg = "查无记录!"; } } catch (Exception ex) { _ErrorMsg = ex.Message; } return(iRtn); }
public override int ExecuteNoQuery(string cmdText, DBHelperParmCollection parameters) { int effectNum; MySqlCommand _MySqlCommand = (MySqlCommand)CreateCommand(cmdText, CommandType.Text); _MySqlCommand.Parameters.Clear(); if (parameters != null) { foreach (DBHelperParm dbPara in parameters) { _MySqlCommand.Parameters.Add(new MySqlParameter("?" + dbPara.Key, dbPara.Value)); } } try { effectNum = _MySqlCommand.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } return(effectNum); }
public override int ExecuteNoQuery(string cmdText, DBHelperParmCollection parameters) { int effectNum; AseCommand _AseCommand = (AseCommand)CreateCommand(cmdText, CommandType.Text); _AseCommand.Parameters.Clear(); if (parameters != null) { foreach (DBHelperParm para in parameters) { _AseCommand.Parameters.Add(new AseParameter("?" + para.Key, EncodingHelper.Default2DB(para.Value, _DBEncodeing))); } } try { effectNum = _AseCommand.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } _AseCommand.Parameters.Clear(); return(effectNum); }
public override DataTable ExecuteProcedureQuery(string procedureName, DBHelperParmCollection parameters) { throw new Exception("The method or operation is not implemented."); }