C#

• There are a lot of conditions. Since they are defined in the WHERE clause you cannot leave any of them empty and expect that the condition would be ignored. If a text box is empty the comparison will still take place
• The operator for all conditions is AND so all the the conditions you have specified must be satisfied by a single row
• You use equality in all comparisons. For example description is compared to the value from the text box using equality. This means that the text must match exactly and completely. This prbably isn't what you're after. Perhaps LIKE comparison?

John L. DeVito wrote:

My plan is to just 'get it working' and then I will go back over it and and change to parameterized queries

private void searchButton_Click(object sender, EventArgs e)
{
    // TODO: This should probably be in the configuration file:
    const string ConnectionString = @"Server=MyAzureServer,MyPortNumber;Database=MyDatabase;User ID=me@MyAzureServer;Password=MyPassword;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;";
    
    const string Query = @"SELECT 
    Title, 
    Director, 
    Genre, 
    ReleaseYear, 
    Length, 
    NumberofDisks, 
    Description 
FROM 
    Base 
WHERE 
    (NullIf(@Title, '') Is Null Or Title = @Title) 
AND 
    (NullIf(@Director, '') Is Null Or Director = @Director) 
AND 
    (NullIf(@Genre, '') Is Null Or Genre = @Genre) 
AND 
    (NullIf(@ReleaseYear, '') Is Null Or ReleaseYear = @ReleaseYear) 
AND 
    (NullIf(@Length, '') Is Null Or Length = @Length) 
AND 
    (NullIf(@NumberOfDisks, '') Is Null Or NumberOfDisks = @NumberOfDisks) 
AND
    (NullIf(@Description, '') Is Null Or Description = @Description)
;";

    DataTable dTable = new DataTable();

    using (SqlConnection connection = new SqlConnection(ConnectionString))
    using (SqlCommand command = new SqlCommand(Query, connection))
    {
        command.Parameters.AddWithValue("@Title", titleTextbox.Text);
        command.Parameters.AddWithValue("@Director", directorTextbox.Text);
        command.Parameters.AddWithValue("@Genre", genreCombobox.GetItemText(genreCombobox.SelectedItem));
        command.Parameters.AddWithValue("@ReleaseYear", yearCombobox.GetItemText(yearCombobox.SelectedItem));
        command.Parameters.AddWithValue("@Length", lengthTextbox.Text);
        command.Parameters.AddWithValue("@NumberOfDisks", numberOfDisksTextbox.Text);
        command.Parameters.AddWithValue("@Description", descriptionTextbox.Text);

        connection.Open();
        using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
        {
            dTable.Load(reader);
        }
    }

    resultsDataGridView.DataSource = dTable;
}

public class Form1 : Form {

  protected override void OnLoad(EventArgs e) {
    base.OnLoad(e);
    this.Text = "One";

    Form f = new Form();
    f.Text = "Two";
    f.Show();
    ISeeAWitch(this, f);
  }

  private void ISeeAWitch(Form bControl, Form dControl) {
    // I don't know who you are but I can point a finger at you
    EventHandler locationChanged = new EventHandler(delegate(Object sender, EventArgs e) {
      dControl.Left = bControl.Right;
      dControl.Top = bControl.Top;
    });

    bControl.LocationChanged += locationChanged;
    
    // I don't know who you are either but I can see that you are pointing at that other guy too
    dControl.FormClosed += new FormClosedEventHandler(delegate(Object sender, FormClosedEventArgs e) {
      if (bControl != null) {
        bControl.LocationChanged -= locationChanged;
        MessageBox.Show("I'm off");
      }
    });
    
    locationChanged(null, null);
  }
}