Data access layer
Use this code for as a .net dataacces layer. It does all the work for you. updating , deleting and adding records and also retreiving datasets , datatables etc
using System;
using System.Text;
using System.Collections;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Data;
using System.Web;
using System.Text;
using System.Text.RegularExpressions;
using System.Web.UI.WebControls;
using Anthem;
namespace CNI.DataAccess
{
///
/// Summary description for Class1.
///
public class CNIdb
{
private string _ConnString;
private string _ErrorMessage;
private ArrayList arrnewparam,arrnewvalue,arrnewoutputparam,arrnewoutputtype;
private bool _Success = false;
public CNIdb()
{
ResetParams();
}
public CNIdb(string m_connstr)
{
ConnString = m_connstr;
ResetParams();
}
public bool Success
{
get{return _Success;}
set{_Success = value;}
}
public string ConnString
{
get{return _ConnString;}
set{ _ConnString = value;}
}
public string ErrorMessage
{
get{return _ErrorMessage;}
set{ _ErrorMessage = value;}
}
public SqlConnection Get_SqlConnection()
{
return new SqlConnection(ConnString);
}
public bool LoadInputParameters(SqlCommand objCmd)
{
bool retvalue = false;
if( (arrnewparam.Count == 0) || (arrnewvalue.Count == 0) )
{
return retvalue;
}
try
{
int nParams = arrnewparam.Count;
for (int i = 0; i < nParams; i++)
{
objCmd.Parameters.Add(arrnewparam[i].ToString(),arrnewvalue[i].ToString());
}
return true;
}
catch(Exception ex)
{
ErrorMessage = ex.ToString();
return retvalue;
}
}
public bool LoadOutPutParameters(SqlCommand objCmd)
{
bool retvalue = false;
if( arrnewoutputparam.Count == 0 )
return retvalue;
try
|
© 2008 dotnetwatch.com -- Privacy policy
Website Design & Internet Marketing by Shivam