I have checked your code. Please refer below. You need to convert the date before checking like i have done in the procedure.
SQL
CREATE TABLE tbl_Games(
[GameID] [int] NOT NULL,
[GameDate] [datetime] NOT NULL,
[AwayTeamCity] [varchar](50) NOT NULL,
[HomeTeamCity] [varchar](50) NOT NULL,
CONSTRAINT [PK_tbl_Games_1] PRIMARY KEY CLUSTERED
(
[GameID] ASC)
)
GO
CREATE TABLE [tbl_Video](
[GameID] [int] NOT NULL,
[VideoID] [int] NOT NULL,
[GameDate] [datetime] NOT NULL,
[VideoName] [varchar](255) NOT NULL,
[VideoURL] [varchar](255) NOT NULL,
[VideoRuntime] [varchar](5) NOT NULL,
CONSTRAINT [PK_tbl_Video] PRIMARY KEY CLUSTERED
(
[GameID] ASC,
[VideoID] ASC)
)
GO
ALTER TABLE [tbl_Video] WITH CHECK ADD CONSTRAINT [FK_tbl_Video_tbl_Games] FOREIGN KEY([GameID])
REFERENCES [tbl_Games] ([GameID])
GO
ALTER TABLE [tbl_Video] CHECK CONSTRAINT [FK_tbl_Video_tbl_Games]
GO
INSERT INTO tbl_Games (GameID, GameDate, AwayTeamCity, HomeTeamCity) VALUES(1, GETDATE(), 'Vancouver', 'Calgary');
INSERT INTO tbl_Games (GameID, GameDate, AwayTeamCity, HomeTeamCity) VALUES(2, GETDATE(), 'Edmonton', 'Red Deer');
INSERT INTO tbl_Games (GameID, GameDate, AwayTeamCity, HomeTeamCity) VALUES(3, GETDATE(), 'Victoria', 'Saskatoon');
INSERT INTO tbl_Games (GameID, GameDate, AwayTeamCity, HomeTeamCity) VALUES(4, GETDATE(), 'Winnipeg', 'Thunder Bay');
INSERT INTO tbl_Games (GameID, GameDate, AwayTeamCity, HomeTeamCity) VALUES(5, GETDATE(), 'Toronto', 'Montreal');
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(1, 1, GETDATE(), 'Vancouver First Goal', 'http://localhost', '0:15');
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(1, 2, GETDATE(), 'Calgary First Goal', 'http://localhost', '0:15');
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(1, 3, GETDATE(), 'Vancouver Second Goal', 'http://localhost', '0:15');
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(2, 1, GETDATE(), 'Edmonton First Goal', 'http://localhost', '0:15');
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(2, 2, GETDATE(), 'Edmonton Second Goal', 'http://localhost', '0:15');
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(2, 3, GETDATE(), 'Edmonton Third Goal', 'http://localhost', '0:15')
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(3, 1, GETDATE(), 'Victoria First Goal', 'http://localhost', '0:15');
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(3, 2, GETDATE(), 'Saskatoon First Goal', 'http://localhost', '0:15');
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(3, 3, GETDATE(), 'Saskatoon Second Goal', 'http://localhost', '0:15')
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(4, 1, GETDATE(), 'Winnipeg First Goal', 'http://localhost', '0:15');
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(4, 2, GETDATE(), 'Thunder Bay First Goal', 'http://localhost', '0:15');
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(4, 3, GETDATE(), 'Winnipeg Second Goal', 'http://localhost', '0:15')
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(5, 1, GETDATE(), 'Montreal First Goal', 'http://localhost', '0:15');
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(5, 2, GETDATE(), 'Montreal Second Goal', 'http://localhost', '0:15');
INSERT INTO tbl_Video(GameID, VideoID, GameDate, VideoName, VideoURL, VideoRuntime) VALUES(5, 3, GETDATE(), 'Mmontreal Third Goal', 'http://localhost', '0:15')
CREATE PROCEDURE [usp_Games_GetGamesByDate]
(@date DATETIME)
AS
BEGIN
SELECT GameID,
AwayTeamCity,
HomeTeamCity
FROM tbl_Games
WHERE CONVERT(VARCHAR(100),GameDate,103) = CONVERT(VARCHAR(100),@date,103)
ORDER BY GameID
END
GO
CREATE PROCEDURE [usp_Video_GetVideoForGame]
(@gameID INT)
AS
BEGIN
SELECT G.GameDate,
G.AwayTeamCity,
G.HomeTeamCity,
V.VideoName,
V.VideoURL,
V.VideoRuntime
FROM tbl_Games G
INNER JOIN tbl_Video V ON G.GameID = V.GameID
WHERE G.GameID = @gameID
ORDER BY G.GameID,V.videoID
END
HTML
<div>
<asp:Calendar ID="Calendar1" runat="server"></asp:Calendar>
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="GameID"
DataSourceID="SqlDataSource1" AutoGenerateSelectButton="true">
<Columns>
<asp:BoundField DataField="GameID" HeaderText="GameID" ReadOnly="True" SortExpression="GameID" />
<asp:BoundField DataField="AwayTeamCity" HeaderText="AwayTeamCity" SortExpression="AwayTeamCity" />
<asp:BoundField DataField="HomeTeamCity" HeaderText="HomeTeamCity" SortExpression="HomeTeamCity" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:conString %>"
SelectCommand="usp_Games_GetGamesByDate" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="Calendar1" Name="Date" PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:GridView ID="GridView2" runat="server" DataSourceID="SqlDataSource2" AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="GameDate" HeaderText="GameDate" SortExpression="GameDate" />
<asp:BoundField DataField="AwayTeamCity" HeaderText="AwayTeamCity" SortExpression="AwayTeamCity" />
<asp:BoundField DataField="HomeTeamCity" HeaderText="HomeTeamCity" SortExpression="HomeTeamCity" />
<asp:BoundField DataField="VideoName" HeaderText="VideoName" SortExpression="VideoName" />
<asp:BoundField DataField="VideoURL" HeaderText="VideoURL" SortExpression="VideoURL" />
<asp:BoundField DataField="VideoRuntime" HeaderText="VideoRuntime" SortExpression="VideoRuntime" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:conString %>"
SelectCommand="usp_Video_GetVideoForGame" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="GridView1" Name="GameID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</div>
Screenshot
