using System;
using System.Data;
using System.Data.OleDb;
namespace All_Examples
{
class OledbDAL
{
string OLEDBConnectionString;
public OledbDAL()
{
OLEDBConnectionString = string.Empty;
}
public OledbDAL(string OLEDBConnectionString)
{
this.OLEDBConnectionString = OLEDBConnectionString;
}
public enum ExecutionType
{
ReturnNothing = 1,
ReturnScalarValue = 2
}
public PropertyCollection ConnectionString
{
get;
set;
}
/// <summary>
/// Get DataTable
/// </summary>
/// <param name="argSQLQry"></param>
/// <returns>DataTable</returns>
public DataTable GetDataTable(string argSQLQry)
{
try
{
using (DataTable datatable = new DataTable())
{
OleDbDataAdapter adapter = new OleDbDataAdapter(argSQLQry, OLEDBConnectionString);
adapter.Fill(datatable);
return datatable;
}
}
catch (Exception)
{
return null;
}
}
/// <summary>
/// Get DataSet
/// </summary>
/// <param name="argSQLQry"></param>
/// <returns>DataSet</returns>
public DataSet GetDataSet(string argSQLQry)
{
try
{
using (DataSet dataset = new DataSet())
{
OleDbDataAdapter adapter = new OleDbDataAdapter(argSQLQry, OLEDBConnectionString);
adapter.Fill(dataset);
return dataset;
}
}
catch (Exception)
{
return null;
}
}
/// <summary>
/// Execute SQL Command
/// </summary>
/// <param name="argSQLQry"></param>
/// <param name="executionCommandType"></param>
/// <returns>Object</returns>
public object ExecuteSQLCommand(string argSQLQry, ExecutionType executionCommandType)
{
try
{
using (OleDbConnection ConnectionString = new OleDbConnection(OLEDBConnectionString))
{
ConnectionString.Open();
using (OleDbCommand command = new OleDbCommand(argSQLQry, ConnectionString))
{
object obj = DBNull.Value;
if (executionCommandType == ExecutionType.ReturnNothing)
obj = command.ExecuteNonQuery() as object;
else
obj = command.ExecuteScalar() as object;
return obj;
}
}
}
catch (Exception)
{
return null;
}
}
}
}
No comments:
Post a Comment
This is a User Friendly Blog.
Simple Interface and Simple Controls are used.
Post your comments so i can modify blog regarding your wish.