protected DataSet ExecuteDataSet(string sqlCommandString)
{
DataSet retDataSet = new DataSet();
try
{
if ((lstDbParameters != null) && (lstDbParameters.Count > 0))
{
for (int i = 0; i < lstDbParameters.Count; i++)
{
string parameter = lstDbParameters[i].ParameterName.ToString();
string value = lstDbParameters[i].Value.ToString();
if (!string.IsNullOrEmpty(parameter))
{
if (value.IndexOf('\'') > -1)
{
value = value.Replace("\'", "\'\'");
}
sqlCommandString = sqlCommandString.Replace(parameter,
"'" + value + "'");
}
}
}
GetConnection();
MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter();
MySqlCommand mySqlCommand = new MySqlCommand(sqlCommandString, mySqlConnection);
mySqlDataAdapter.SelectCommand = mySqlCommand;
mySqlDataAdapter.Fill(retDataSet);
}
catch (MySqlException ex)
{
MySqlEXP mySqlExp = new MySqlEXP(ex.Message + "\r\n Query : " + sqlCommandString, ex);
throw mySqlExp;
}
catch (Exception ex)
{
throw ex;
}
finally
{
CloseConnection();
}
CloseConnection();
return retDataSet;
}
protected object ExecuteScalar(string sqlCommandString)
{
object iRetVal = -9;
try
{
if ((lstDbParameters != null) && (lstDbParameters.Count > 0))
{
for (int i = 0; i < lstDbParameters.Count; i++)
{
if (!string.IsNullOrEmpty(lstDbParameters[i].ParameterName.ToString()))
{
sqlCommandString = sqlCommandString.Replace(lstDbParameters[i].ParameterName.ToString(),
"'" + lstDbParameters[i].Value.ToString() + "'");
}
}
}
GetConnection();
MySqlCommand mySqlCommand = new MySqlCommand(sqlCommandString, mySqlConnection);
if (lstDbParameters != null)
{
lstDbParameters.Clear();
}
iRetVal = mySqlCommand.ExecuteScalar();
if (iRetVal == null)
{
iRetVal = -9;
}
}
catch (MySqlException ex)
{
MySqlEXP mySqlExp = new MySqlEXP(ex.Message + "\r\n Query : " + sqlCommandString, ex);
throw mySqlExp;
}
catch (Exception ex)
{
throw ex;
}
finally
{
CloseConnection();
}
CloseConnection();
return iRetVal;
}