rendered paste body override public DataSet doSelect(string query,DataSet ds)
{
Open();
NpgsqlConnection conn = ( (NpgsqlConnection) dbCon );
NpgsqlDataAdapter da = new NpgsqlDataAdapter(query,conn);
query = query.Trim();
if (query.StartsWith(";"))
query = query.Substring(1);
string[] sqls = query.Split(';');
int counter = 0;
for (int i =0; i< sqls.Length;i++)
{
da = new NpgsqlDataAdapter(sqls[i],conn);
try
{
da.Fill(ds,"tbl"+counter++);
}
catch(Exception ex)
{
Close();
Logger.Log("Error executing query:\r\n" + query, LogLevel.Trace);
throw new Exception("Error executing query:\r\n" + query + "\n\r" +ex.Message,ex.InnerException);
}
da.Dispose();
}
Close();
return ds;
}