[Quantproject-developers] QuantProject/b2_DataAccess SqlExecutor.cs,NONE,1.1

[Glauco S. <gla...@us...>]

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26190/b2_DataAccess

Added Files:
	SqlExecutor.cs 
Log Message:
Executes Sql queries returning a DataTable

--- NEW FILE: SqlExecutor.cs ---
using System;
using System.Data;
using System.Data.OleDb;

namespace QuantProject.DataAccess
{
	/// <summary>
	/// Executes Sql queries returning a DataTable
	/// </summary>
	public class SqlExecutor
	{
		public SqlExecutor()
		{
			//
			// TODO: Add constructor logic here
			//
		}
		public static DataTable GetDataTable( string SqlQuery )
		{
			DataTable dataTable = new DataTable();
			OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter( SqlQuery , ConnectionProvider.OleDbConnection );
			oleDbDataAdapter.Fill( dataTable );
			return dataTable;
		}
		public static void ExecuteNonQuery( string SqlNonQuery )
		{
			OleDbCommand oleDbCommand = new OleDbCommand( SqlNonQuery ,
				ConnectionProvider.OleDbConnection );
			oleDbCommand.ExecuteNonQuery();
		}
	}
}