Question

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

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，获取信息失败</returns public 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; //添加参数newsID SqlParameter 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();