SQL 通用存储过程

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
/// <summary>
/// CommonProc 的摘要说明
/// </summary>
public class CommonProc
{
public CommonProc()
{
//
// TODO: 在此处添加构造函数逻辑
//
}

public static DataSet CommonProcSel(string procname, params object[] obj)
{
using (SqlConnection sqlcon = new SqlConnection("server=SAMSUNG-B76C7F0;database=ASPNETDB;uid=sa;pwd=sasa;"))
{
sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.Connection = sqlcon;
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.CommandText = procname;


SqlCommandBuilder.DeriveParameters(sqlcmd);
sqlcmd.Parameters.RemoveAt(0);

for (int i = 0; i < sqlcmd.Parameters.Count; i++)
{
sqlcmd.Parameters[i].Value = obj[i];
}

SqlDataAdapter sqldap = new SqlDataAdapter();
sqldap.SelectCommand = sqlcmd;

DataSet ds = new DataSet();
sqldap.Fill(ds);

return ds;

}
}

public static bool CommonProcTSG(string procname, params object[] obj)
{
using (SqlConnection sqlcon = new SqlConnection("server=SAMSUNG-B76C7F0;database=ASPNETDB;uid=sa;pwd=sasa;"))
{
sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.CommandText = procname;
sqlcmd.Connection = sqlcon;

SqlCommandBuilder.DeriveParameters(sqlcmd);
sqlcmd.Parameters.RemoveAt(0);