Asp.Net 中通用存储过程执行方法

最新推荐文章于 2019-07-24 23:35:32 发布

samying

最新推荐文章于 2019-07-24 23:35:32 发布

阅读量511

点赞数

分类专栏： ASP.NET 文章标签：存储 asp.net dataset string

本文链接：https://blog.csdn.net/samying/article/details/1778773

版权

ASP.NET 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

/// <summary>
  /// 执行带返回参数的存储过程
  /// </summary>
  /// <param name="StoreProcedureName">存储过程名称</param>
  /// <param name="parms">参数数组</param>
  /// <param name="intPTNum" >返回参数个数</param>
  public SqlParameter[] ExecuteStoreProcedure(string StoreProcedureName,SqlParameter[] parms,int intPTNum)
  {
   try
   {
    int intJ = 0;
    SqlParameter[] parmsRTN = new SqlParameter[intPTNum];   //返回参数
    SqlCommand objCmd = new SqlCommand(StoreProcedureName);
    objCmd.Connection = this.CurrentConnection;
    objCmd.CommandType = CommandType.StoredProcedure;

    //增加参数
    for(int i=0;i<parms.Length;i++)
    {
     objCmd.Parameters.Add(parms[i]);
    }

    objCmd.ExecuteNonQuery();

    //得到返回参数
    for (int i=0;i<objCmd.Parameters.Count;i++)
    {
     if(objCmd.Parameters[i].Direction == ParameterDirection.Output)
     {
      parmsRTN[intJ]=objCmd.Parameters[i];
      intJ++;
     }
    }

return parmsRTN;

   }
   catch(SqlException e)
   {
    throw e;
   }

}

  /// <summary>
  /// 执行返回记录集的存储过程
  /// </summary>
  /// <param name="StoreProcedureName">存储过程名称</param>
  /// <param name="parms">参数数组</param>
  public DataSet ExecuteStoreProcedure(string StoreProcedureName,SqlParameter[] parms)
  {
   try
   {
    SqlCommand objCmd = new SqlCommand(StoreProcedureName);
    objCmd.Connection = this.CurrentConnection;
    objCmd.CommandType = CommandType.StoredProcedure;

    //增加参数
    for(int i=0;i<parms.Length;i++)
    {
     objCmd.Parameters.Add(parms[i]);
    }

    SqlDataAdapter objDataAdapter = new SqlDataAdapter();
    objDataAdapter.SelectCommand = objCmd;

    DataSet objDataSet = new DataSet();
    objDataAdapter.Fill(objDataSet);

    return objDataSet;
   }
   catch(SqlException e)
   {
    throw e;
   }

}