All pastes #12561 Raw Edit

Mine

public text v1 · immutable
#12561 ·published 2005-05-24 23:52 UTC
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;

		}