title: output parameter into label
body: <p>instead of returning my output paremeter value in my stored procedure to my label it returns the default value i set my output parameter to. </p>
  
  <p>why cant i put my output parameter into my text label     </p>
  
  <pre><code>Dim reader As SqlDataReader
  cmd.Parameters.AddWithValue("@tour", "2365")
  
  cmd.Parameters.Add("@tourname", SqlDbType.VarChar)
  cmd.Parameters("@tourname").Direction = ParameterDirection.Output
  
  
  cmd.CommandText = "test"
  cmd.CommandType = CommandType.StoredProcedure
  cmd.Connection = conn
  conn.Open()
  reader = cmd.ExecuteReader()
  
  Dim myTable As DataTable = New DataTable()
  
  myTable.Load(reader)
  
  
  DropDownList1.DataSource = myTable
  DropDownList1.DataTextField = "ddate7"
  DropDownList1.DataBind()
  
  
  
  Label1.Text = cmd.Parameters("@tourname").ToString
  
  conn.Close()
  </code></pre>