Create Data Access class

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Collections;

///

/// Summary description for DataAccess
///

public class DataAccess
{
public DataAccess()
{
//
// TODO: Add constructor logic here
//
}

///

/// Get Data Set
///

///
/// DBRequest object
///
/// Data Set
#region Get Data Set...
public static DataSet GetDataSet(DBRequest _objDBRequest)
{
DataSet _dataSet = new DataSet();
bool _isOpenSqlConnection=false;

try
{
///Open Sql Connection...
_isOpenSqlConnection = _objDBRequest.OpenSQLConnection();

if (_isOpenSqlConnection)
{
///Sql Command...
SqlCommand _sqlCommand = new SqlCommand(_objDBRequest.SqlCommandText, _objDBRequest.SqlConnection);
_sqlCommand.CommandType = _objDBRequest.SqlComandType;
SqlParameter _sqlParameter = null;


///Get Sql Parameter...
Hashtable _parameterhashTbl = _objDBRequest.Parameter;

if (_parameterhashTbl.Count > 0)
{
foreach (string key in _parameterhashTbl.Keys)
{
_sqlParameter = (SqlParameter)_objDBRequest.Parameter[key];
_sqlCommand.Parameters.Add(_sqlParameter);
}
}

///Fill Dataset
SqlDataAdapter _sqlDataAdapter = new SqlDataAdapter(_sqlCommand);
_sqlDataAdapter.Fill(_dataSet);
}
}
catch (SqlException sqlExe)
{
_objDBRequest.Exception = sqlExe;
}
finally
{
if (_isOpenSqlConnection && _objDBRequest.SqlConnection.State == ConnectionState.Open)
{
///Close Sql Connection...
_objDBRequest.CloseSqlConnection();
}
}

return _dataSet;
}
#endregion

///

/// ExecuteNon Query...
///

///
///
#region ExecuteNon Query...
public static bool ExecuteNonQuery(DBRequest _objDBinsertRequest)
{
bool _isInsertedRow = false;
bool _isOpenSqlConnection = false;

try
{
_isOpenSqlConnection = _objDBinsertRequest.OpenSQLConnection();

if (_isOpenSqlConnection)
{
///Sql Command...
SqlCommand _sqlCommand = new SqlCommand(_objDBinsertRequest.SqlCommandText, _objDBinsertRequest.SqlConnection);
_sqlCommand.CommandType = _objDBinsertRequest.SqlComandType;
SqlParameter _sqlParameter = null;

///Get Sql Parameter...
Hashtable _parameterhashTbl = _objDBinsertRequest.Parameter;

if (_parameterhashTbl.Count > 0)
{
foreach (string key in _parameterhashTbl.Keys)
{
_sqlParameter = (SqlParameter)_objDBinsertRequest.Parameter[key];
_sqlCommand.Parameters.Add(_sqlParameter);
}
}

int _i=_sqlCommand.ExecuteNonQuery();

_isInsertedRow = true;
}
}
catch (Exception ex)
{
_isInsertedRow = false;
_objDBinsertRequest.Exception = ex;
}
finally
{
if (_isOpenSqlConnection && _objDBinsertRequest.SqlConnection.State == ConnectionState.Open)
{
///Close Sql Connection...
_objDBinsertRequest.CloseSqlConnection();
}
}

return _isInsertedRow;
}
#endregion
}