Line 108: GridView1.DataBind()
Line 109: End If
Line 110: drpListTidspunkt = CDate(DropDownList1.SelectedItem.Value).ToString("yyyy-MM-dd HH:mm:ss")
Line 111: SqlDataSource2.SelectCommand = "SELECT [Id],[Tidspunkt],[VisesNavn] FROM [Tilmeldinger" & ProjektNavn & "] WHERE [Venteliste]=0 AND [Tidspunkt] ='" & drpListTidspunkt & "' ORDER BY CASE WHEN [TilmeldtTidspunkt] IS NULL THEN 1 ELSE 0 END, [TilmeldtTidspunkt];" ' "SELECT DISTINCT [Tidspunkt] FROM [FoedselsdagsBookinger] WHERE [BestillersForkNavn]='Stadig LEDIG' AND [BookingTidspunkt] > #" & CDate(Label16.Text).ToString("MM/dd/yyyy") & " 00:00:00# AND [BookingTidspunkt] < #" & CDate(Label16.Text).ToString("MM/dd/yyyy") & " 23:59:59# ORDER BY [BookingTidspunkt];"
Line 112: SqlDataSource3.SelectCommand = "SELECT [Id],[Tidspunkt],[VisesNavn] FROM [Tilmeldinger" & ProjektNavn & "] WHERE [Venteliste]=1 AND [Tidspunkt] ='" & drpListTidspunkt & "' ORDER BY CASE WHEN [TilmeldtTidspunkt] IS NULL THEN 1 ELSE 0 END, [TilmeldtTidspunkt];" ' "SELECT DISTINCT [Tidspunkt] FROM [FoedselsdagsBookinger] WHERE [BestillersForkNavn]='Stadig LEDIG' AND [BookingTidspunkt] > #" & CDate(Label16.Text).ToString("MM/dd/yyyy") & " 00:00:00# AND [BookingTidspunkt] < #" & CDate(Label16.Text).ToString("MM/dd/yyyy") & " 23:59:59# ORDER BY [BookingTidspunkt];"
|