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:
Post a Comment