Monday, January 12, 2009

Execute Procedures Class

This class have two procedure . both are used in insert, update and delete oeration.
First one function is used to perform insert, update and delete oeration.
second function is used to perform insert, update and delete oeration and return selected table.

using System;
using System.Data;
using System.Data.SqlClient;
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;

///
/// Summary description for clsExecuteProcedures
///

public class clsExecuteProcedures
{
clsConnection conn = new clsConnection(); // connection class object
int iSizeParam;
int iCount;

public bool dbUpdate(SqlParameter[] v_arrParam, string v_sStoredProcedure,bool v_bIsExecute)
{
try
{
conn.gSqlConnection = new SqlConnection(conn.gSqlConnectionString);
conn.gSqlConnection.Open();
conn.gSqlCommand = new SqlCommand(v_sStoredProcedure, conn.gSqlConnection);
conn.gSqlCommand.CommandType = CommandType.StoredProcedure;

iSizeParam = v_arrParam.Length;

for (iCount = 0; iCount < iSizeParam; iCount++)
{
conn.gSqlCommand.Parameters.Add(v_arrParam[iCount]);
}

conn.gSqlCommand.ExecuteNonQuery();
conn.gSqlConnection.Close();

v_bIsExecute = true;
return v_bIsExecute;
}
catch
{
v_bIsExecute = false;
return v_bIsExecute;
}
}

// this function return select value from the database.
public DataTable dbUpdateReturnId(SqlParameter[] v_arrParam, string v_sStoredProcedure)
{
try
{
conn.gDataTable = new DataTable();
conn.gSqlDataAdapter = new SqlDataAdapter();
conn.gSqlConnection = new SqlConnection(conn.gSqlConnectionString);
conn.gSqlConnection.Open();
conn.gSqlCommand = new SqlCommand(v_sStoredProcedure, conn.gSqlConnection);
conn.gSqlCommand.CommandType = CommandType.StoredProcedure;

iSizeParam = v_arrParam.Length;
for (iCount = 0; iCount < iSizeParam; iCount++)
{
conn.gSqlCommand.Parameters.Add(v_arrParam[iCount]);
}

conn.gSqlDataAdapter.SelectCommand = conn.gSqlCommand;
conn.gSqlDataAdapter.Fill(conn.gDataTable);
conn.gSqlConnection.Close();
}
catch
{

return conn.gDataTable;

}
return conn.gDataTable;
}
}

No comments: