»Dotnet Ads
»Message Boards
Message Boards
Dotnet Books
»Member Details
Register
Login
LogOut
Submit Code
Submit Jobs
Submit Projects
»Competition
Community
Winners
Prizes
Write For Us
Members
»Other Resources
Links
Dotnet Resources
|
Data access layerUse 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
|