asp.net 存储过程

SqlConnection conn = new SqlConnection();

conn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["connstr"].Trim();

SqlCommand comm = new SqlCommand();
        comm.Connection = conn;
        comm.CommandText = "chg_Fee";
        comm.CommandType = CommandType.StoredProcedure;
        SqlParameter param = new SqlParameter();
        param = new SqlParameter("@userid", SqlDbType.Int);
        comm.Parameters.Add(param);
        param.Value = userid;
        param = new SqlParameter("@fee", SqlDbType.Float);
        comm.Parameters.Add(param);
        param.Value = fee;
        param = new SqlParameter("@title", SqlDbType.VarChar,30);
        comm.Parameters.Add(param);
        param.Value = title;
        param = new SqlParameter("@order", SqlDbType.VarChar,50);
        comm.Parameters.Add(param);
        param.Value = order;
        comm.ExecuteNonQuery();
        comm.Parameters.Clear();

conn.close();

coo.dispose();