用ASP调用SQL2000里的储存过程，要求有参数和返回值

Question

 /// <summary>
        /// 根据条件查找列表
        /// </summary>
        /// <param name="SendUnit_ch"></param>
        /// <param name="SendPerson_ch"></param>
        /// <param name="SendTime_Start"></param>
        /// <param name="SendTime_End"></param>
        /// <returns></returns>
        public DataSet GetMeasureReceiveByConditionc(string SendUnit_ch, string SendPerson_ch, DateTime SendTime_Start, DateTime SendTime_End)
        {
            DataSet ds = new DataSet();
            try
            {
                SqlConnection con = new SqlConnection(sqlConStr);
                SqlCommand cmd = con.CreateCommand();
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "GetMeasureReceiveByCondition";
                SqlParameter spa1 = new SqlParameter("@SendUnit_ch", SqlDbType.VarChar);
                spa1.Value = SendUnit_ch;
                cmd.Parameters.Add(spa1);
                SqlParameter spa2 = new SqlParameter("@SendPerson_ch", SqlDbType.VarChar);
                spa2.Value = SendPerson_ch;
                cmd.Parameters.Add(spa2);
                SqlParameter spa = new SqlParameter("@SendTime_Start", SqlDbType.DateTime);
                spa.Value = SendTime_Start;
                cmd.Parameters.Add(spa);
                SqlParameter spa3 = new SqlParameter("@SendTime_End", SqlDbType.DateTime);
                spa3.Value = SendTime_End;
                cmd.Parameters.Add(spa3);
                SqlDataAdapter sdap = new SqlDataAdapter(cmd);
                sdap.Fill(ds);
            }
            catch (Exception ex)
            {
                string errot = ex.Message;
            }
            return ds;
        }
没太看明白你到底要什么，且给你个调用存储过程的例子吧

Answer 1

懒 得写了。。自己都 不搜下，我也就粘个给你吧http://faq.csdn.net/read/133244.html

Answer 2

au_id=724-80-9391
au_lname=MacFeather
au_fname=Stearns
phone=415 354-7128
address=44 Upland Hts.
city=Oakland
state=CA
zip=94612
contract=Trueau_id=893-72-1158
au_lname=McBadden
au_fname=Heather
phone=707 448-4982
address=301 Putnam
city=Vacaville
state=CA
zip=95688
contract=False
@intIDOut = Return value = 
长的那个例子我执行后，最后两行怎么没有把想要的结果打印出来？