C#

"Another possible solution that doesn’t require you to create a new type is using a Func delegate. Like so:

Func<int, string, Tuple<int, string>> c = Tuple.Create;
var list = new List<Tuple<int, string>>
{
c(1, "apples"),
c(2, "kiwiws"),
};"

private void searchButton_Click(object sender, EventArgs e)
{
	string qString = @"SELECT Title, Director, Genre, ReleaseYear, Length, NumberofDisks, Description FROM Base WHERE Title = '" + titleTextbox.Text + "' AND Director = '" + directorTextbox.Text + "' AND Genre = '" + genreCombobox.GetItemText(genreCombobox.SelectedItem) + "' AND ReleaseYear = '" + yearCombobox.GetItemText(yearCombobox.SelectedItem) + "' AND Length = '" + lengthTextbox.Text + "' AND NumberOfDisks = '" + numberOfDisksTextbox.Text + "' AND Description = '" + descriptionTextbox.Text + "';";
	
    string cString = @"Server=MyAzureServer,MyPortNumber;Database=MyDatabase;User ID=me@MyAzureServer;Password=MyPassword;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;";

	DataTable dTable = new DataTable();

	SqlConnection sConnection = new SqlConnection(cString);

	sConnection.Open();

	using(SqlCommand sCommand = new SqlCommand(qString, sConnection))
        {
        	try
		{
			SqlDataReader sReader = sCommand.ExecuteReader();
			dTable.Load(sReader);
		}
		catch(SqlException sEx)
		{
			MessageBox.Show(sEx.Message);
		}

		resultsDataGridView.DataSource = dTable;
	}

		sConnection.Close();
}

CREATE TABLE [dbo].[Base]
(
	[MediaID] [int] IDENTITY(1,1) PRIMARY KEY,
	[Title] [nvarchar](50) NOT NULL,
	[Director] [nvarchar](50) NULL,
	[Genre] [nvarchar](50) NULL,
	[ReleaseYear] [date] NULL,
	[Length] [time] NULL,
	[NumberOfDisks] [int] NULL,
	[Description] [nvarchar](200) NULL
)