如何避免c#中来自绑定数据表的重复行

我的场景很简单，但我很难在编码中实现它。

我有两个名为film和filmtime的表。我使用sql查询连接两个表，并从datatable绑定到gridview。

膜表结构为，

theatrename     filmname
   max          Spiderman
   well         Godzilla

电影时间表结构为，

theatrename      time
   max           10:00 am
   max           01:00 pm
   max           04:00 pm
   well          11:30 am

我希望我的输出为，

 theatrename     filmname     time
                              10:00 am
   max            Spiderman   01:00 pm
                              04:00 pm  
   well           Godzilla    11:30 am

我使用了这样的查询。

 SELECT film.theatrename,film.filmname,filmtime.time FROM film  left join filmtime on film.theatrename=filmtime.theatrename

通过使用这个查询，我得到这样的结果，

theatrename     filmname     time
   max           Spiderman    10:00 am
   max           Spiderman    01:00 pm
   max           Spiderman    04:00 pm  
   well           Godzilla    11:30 am       

任何帮助都会对我更有帮助。提前感谢。

public void FillGridview()
{
    reader = Select * from film;
    while (reader.Read())
    {
        reader2 = Select time from filmtime where theatername = reader["theatername"];
        //add the filmname and the theatrename to the gridview-cells here
        while (reader2.Read())
        {
            //add the times to the gridview-cell here (You can start a new line if you want a break with Environment.NewLine()
        }
    }
}