title: sql search query in c#
body: <p>I'm trying to make a database search in my app where the user would choose the column and enter the search word and the result would come up in a dataviewgrid.
  This is the code i've been working on, the problem is that nothing comes up and i'm pretty sure there are entries in the database. EDIT : it's a windows form application</p>
  
  <pre><code>private void button1_Click(object sender, EventArgs e)
      {
          conn = new SqlConnection("Server = localhost; database = Clients; Integrated Security = SSPI");
          conn.Open();
          SqlCommand cmd = new SqlCommand("SELECT * From dbo.Tclients WHERE @choice = @input", conn);
          cmd.Parameters.AddWithValue("@choice", comboBox1.Text);
          cmd.Parameters.AddWithValue("@input", textBox1.Text);
          ds = new DataSet();
          da = new SqlDataAdapter(cmd);
          da.Fill(ds);
          dataGridView1.DataSource = ds.Tables[0];
          conn.Close();
      }
  </code></pre>