Filter Data Grid With calendar control

[Joey Durham]

Hi,

Hope this is the correct forum to post in. I am new to ASP.NET. I have a
calendar control that I am using to select a date and then that date will
list all records that match the date selected in a datagrid. I have
everything set up but I am unable to get any records to show up. .NET still
has me a bit puzzled.

Here is the code I have on my code behind page and my sql statement. Any
help greatly appreciated.

Thanks.
Joey Durham
www.ultraweaver.com

SQL
SELECT
EndDate,
EventID,
EventName,
EventTypeID,
StartDate
FROM
Events
WHERE
(StartDate = @calStartDate)

CODE BEHIND
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load

'Put user code to initialize the page here

daEmployeeList. Fill(DsEmployee List)

If IsPostBack Then

dgEventList.Dat aBind()

ddlEmployees.Da taBind()

txtStartDate.Te xt = calStartDate.Se lectedDate.ToSh ortDateString

txtEndDate.Text = calEndDate.Sele ctedDate.ToShor tDateString

End If

End Sub

Private Sub calStartDate_Se lectionChanged( ByVal sender As Object, ByVal e As
System.EventArg s) Handles calStartDate.Se lectionChanged

txtStartDate.Te xt = calStartDate.Se lectedDate.ToSh ortDateString

End Sub

Private Sub calEndDate_Sele ctionChanged(By Val sender As Object, ByVal e As
System.EventArg s) Handles calEndDate.Sele ctionChanged

txtEndDate.Text = calEndDate.Sele ctedDate.ToShor tDateString

[David Waz...]

looks like you forgot to define your datasource:

dgEventList.Dat aSource = o_DataTable.Def aultView
dgEventList.Dat aBind

g.l.

"Joey Durham" <jo**@ultraweav er.com> wrote in message
news:eE******** ******@tk2msftn gp13.phx.gbl...

Hi,

Hope this is the correct forum to post in. I am new to ASP.NET. I have a
calendar control that I am using to select a date and then that date will
list all records that match the date selected in a datagrid. I have
everything set up but I am unable to get any records to show up. .NET still has me a bit puzzled.

Here is the code I have on my code behind page and my sql statement. Any
help greatly appreciated.

Thanks.
Joey Durham
www.ultraweaver.com

SQL
SELECT
EndDate,
EventID,
EventName,
EventTypeID,
StartDate
FROM
Events
WHERE
(StartDate = @calStartDate)

CODE BEHIND
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load

'Put user code to initialize the page here

daEmployeeList. Fill(DsEmployee List)

If IsPostBack Then

dgEventList.Dat aBind()

ddlEmployees.Da taBind()

txtStartDate.Te xt = calStartDate.Se lectedDate.ToSh ortDateString

txtEndDate.Text = calEndDate.Sele ctedDate.ToShor tDateString

End If

End Sub

Private Sub calStartDate_Se lectionChanged( ByVal sender As Object, ByVal e As System.EventArg s) Handles calStartDate.Se lectionChanged

txtStartDate.Te xt = calStartDate.Se lectedDate.ToSh ortDateString

End Sub

Private Sub calEndDate_Sele ctionChanged(By Val sender As Object, ByVal e As
System.EventArg s) Handles calEndDate.Sele ctionChanged

txtEndDate.Text = calEndDate.Sele ctedDate.ToShor tDateString