/// <summary> /// Execute DataSet with query directly passed as parameter /// </summary> /// <param name="sSelectMySql">Select Query</param> /// <param name="colParameterList">Array of NandanaDBRequest.Parameter containing Name and value pair</param> /// <returns>DataSet Object</returns> public override NandanaDataSet ExecuteDataSet(string sSelectMySql, ArrayList colParameterList) { // implementation code here... MySqlConnection conMySql = new MySqlConnection(); MySqlCommand cmdMySql = new MySqlCommand(); MySqlDataAdapter daMySql; NandanaMySqlDataSet oDataSetMySql = new NandanaMySqlDataSet(); NandanaDBRequest oRequest = new NandanaDBRequest(sSelectMySql, CommandType.Text, null, colParameterList); try { PrepareCommand(cmdMySql, conMySql, null, oRequest); daMySql = new MySqlDataAdapter(cmdMySql); daMySql.Fill(oDataSetMySql.ReturnedDataSet); } catch (MySqlException ex) { throw (ex); } finally { if (cmdMySql != null) { cmdMySql.Parameters.Clear(); } if (conMySql.State == ConnectionState.Open) { conMySql.Close(); } } return(oDataSetMySql); }
/// <summary> /// Execute DataSet /// </summary> /// <param name="Request">NandanaDBRequest with connection details</param> /// <returns>DataSet Object</returns> public override NandanaDataSet ExecuteDataSet(NandanaDBRequest Request) { // implementation code here... MySqlConnection conMySql = new MySqlConnection(); MySqlCommand cmdMySql = new MySqlCommand(); MySqlDataAdapter daMySql; NandanaMySqlDataSet oDataSetMySql = new NandanaMySqlDataSet(); MySqlTransaction tranMySql = null; try { if (Request.Transaction != null) { tranMySql = Request.Transaction; } PrepareCommand(cmdMySql, conMySql, tranMySql, Request); daMySql = new MySqlDataAdapter(cmdMySql); daMySql.Fill(oDataSetMySql.ReturnedDataSet); } catch (MySqlException ex) { if (conMySql.State == ConnectionState.Open) { conMySql.Close(); } throw (ex); } finally { if (cmdMySql != null) { cmdMySql.Parameters.Clear(); } if ((Request.Transaction == null) && (conMySql.State == ConnectionState.Open)) { conMySql.Close(); } } return(oDataSetMySql); }