ASP.NET 如何获取带有返回值的存储过程

Question

如题所述

Answer 1

/// <summary/// 获取指定信息的数据集/// </summary/// <param name="strSqlAdminSession"后台登陆用户</param/// <param name="int_DoID"指定信息的ID</param/// <param name="P_Str_srcTable"信息临时表</param/// <param name="Proc_tb_GetByID"存储过程名称</param/// <param name="str_ProcID"存储过程参数名称，为某条信息的ID值参数</param/// <returnsint值，返回影响的行数，如果为-1，获取信息失败</returnspublic DataSet DO_dsGetInforByID(string strSqlAdminSession, int int_DoID, string P_Str_srcTable, string Proc_tb_GetByID, string str_ProcID){DataSet returnValue = new DataSet();returnValue = null;//将返回值的初始值设置为空if (strSqlAdminSession == "" || strSqlAdminSession == null){return returnValue;}else{SqlConnection MyConn = dbObj.GetConnection();SqlCommand MyCmd = new SqlCommand(Proc_tb_GetByID, MyConn);MyCmd.CommandType = CommandType.StoredProcedure;//添加参数newsIDSqlParameter spDoID = new SqlParameter(str_ProcID, SqlDbType.Int);spDoID.Value = int_DoID;MyCmd.Parameters.Add(spDoID);MyConn.Open();try{MyCmd.ExecuteNonQuery();SqlDataAdapter da = new SqlDataAdapter(MyCmd);DataSet ds = new DataSet();