title: SqlDataReader parameter not working
body: <p>I have a windows form that I am asking a user to enter a pcname in textbox1 and then trying to use <code>SqlDataReader</code> to the read from the database to get the pc ipaddress and then map the pc drive to my local pc. </p>
  
  <p>But for some reason when I use the textbox within the SQL parameter it's not working. But when I replace the <code>textbox1.text</code> with the actual pcname it works fine. Hopefully someone can help me find out why the parameter isn't working correctly. </p>
  
  <p>Here is my code:</p>
  
  <pre><code>public void button1_Click(object sender, EventArgs e)
  {
      string results = "";
  
      using (SqlConnection cs = new SqlConnection(@"***removed connection string***"))
      {
          cs.Open();
  
          string query = "select stationipaddress from station where stationname = @StationName";
  
          using (SqlCommand cmd = new SqlCommand(query, cs))
          {
              // Add the parameter and set its value -- 
              cmd.Parameters.AddWithValue("@StationName", textBox1.Text);
  
              using (SqlDataReader dr = cmd.ExecuteReader())
              {
                  while (dr.Read())
                  {
                      label3.Text = dr.GetSqlValue(0).ToString();
                      results = dr.GetValue(0).ToString();
                      MessageBox.Show(dr.GetValue(0).ToString());
                      MessageBox.Show(results);
                  }
  
                  string myvar = string.Format(@"use S: \\" + label3.Text + "\\c$\logs 0A36303 /user:admin", label3.Text);
  
                  Process p = new Process();
                  p.StartInfo.FileName = "net.exe";
                  p.StartInfo.Arguments = (myvar);
                  p.StartInfo.UseShellExecute = false;
                  p.StartInfo.RedirectStandardOutput = true;
                  p.StartInfo.RedirectStandardInput = true;
                  p.StartInfo.CreateNoWindow = true;
                  p.Start();
  </code></pre>