ASP.net(C#)调用带参数的存储过程

  //调用存储过程。
        public static DataSet getProResult(string querystr){
            string[] parmrr = querystr.Split(',');
            SqlConnection conn = new SqlConnection(connectionString);
            SqlDataAdapter da = new SqlDataAdapter();
            SqlCommand mycommand = new SqlCommand("pro_analyse_tsedu", conn);
            mycommand.CommandType = CommandType.StoredProcedure;

            mycommand.Parameters.Add("@startDate", SqlDbType.Char, 10);
            mycommand.Parameters.Add("@startTime", SqlDbType.Char, 5);
            mycommand.Parameters.Add("@endDate", SqlDbType.Char, 10);
            mycommand.Parameters.Add("@endTime", SqlDbType.Char, 5);
            mycommand.Parameters.Add("@bucode", SqlDbType.Char, 6);

            mycommand.Parameters["@startDate"].Value = "2013/11/28";
            mycommand.Parameters["@startTime"].Value = "00:00";
            mycommand.Parameters["@endDate"].Value ="2013/11/28";
            mycommand.Parameters["@endTime"].Value = "23:59";
            mycommand.Parameters["@bucode"].Value = "670008";


            conn.Open();
            da.SelectCommand = mycommand;
            DataSet myds = new DataSet();
            da.Fill(myds, "tableName");

            conn.Close();

            return myds;
           
            
        }