SqlConnection sqlconnection1= new SqlConnection("Data Source=JULU;Initial Catalog=Cinema;Integrated Security=True");   
int year = dateTimePicker1.Value.Year;
int month = dateTimePicker1.Value.Month;
int day = dateTimePicker1.Value.Day;
string date=year+"-"+month+"-"+day;
string command = "SELECT Movies.MovieName,Movie_Showings.Showing_From_Date, Movie_Showings.Showing_To_Date FROM Movie_Showings INNER JOIN Movies ON Movie_Showings.Movie_ID = Movies.MovieID   where   Movie_Showings.Showing_From_Date<='" + date + "' and Movie_Showings.Showing_To_Date>='" + date + "'";
SqlCommand sqlcommand1 = new SqlCommand(command, sqlconnection1);
DataSet dataset1 = new DataSet();
SqlDataAdapter SqlDataAdapter1 = new SqlDataAdapter();
sqlDataAdapter1.SelectCommand = sqlcommand1;
sqlConnection1.Open();
sqlDataAdapter1.Fill(dataSet1, "Films");
dataGrid1.DataMember = "Films";
dataGrid1.DataSource = dataset1;
sqlconnection1.Close();