Data access layer

»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 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

Have a Question and dont know the answer post it below and get answers in minutes

Due to spam this feature is disabled
To get answers fast , make sure you enter a detailed subject for example: "DataGrid issues need answer" not "DataGrid"

Subject:

Catjegory Name:

Message: