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
[url]www.ultraweaver.com[/url]

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.EventArgs) Handles MyBase.Load

'Put user code to initialize the page here

daEmployeeList.Fill(DsEmployeeList)

If IsPostBack Then

dgEventList.DataBind()

ddlEmployees.DataBind()

txtStartDate.Text = calStartDate.SelectedDate.ToShortDateString

txtEndDate.Text = calEndDate.SelectedDate.ToShortDateString

End If

End Sub

Private Sub calStartDate_SelectionChanged(ByVal sender As Object, ByVal e As
System.EventArgs) Handles calStartDate.SelectionChanged

txtStartDate.Text = calStartDate.SelectedDate.ToShortDateString

End Sub

Private Sub calEndDate_SelectionChanged(ByVal sender As Object, ByVal e As
System.EventArgs) Handles calEndDate.SelectionChanged

txtEndDate.Text = calEndDate.SelectedDate.ToShortDateString

[David Waz...]

looks like you forgot to define your datasource:

dgEventList.DataSource = o_DataTable.DefaultView
dgEventList.DataBind

g.l.

"Joey Durham" <joey@ultraweaver.com> wrote in message
news:eEVB47zQDHA.4024@tk2msftngp13.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
> [url]www.ultraweaver.com[/url]
>
> 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.EventArgs) Handles MyBase.Load
>
> 'Put user code to initialize the page here
>
> daEmployeeList.Fill(DsEmployeeList)
>
> If IsPostBack Then
>
> dgEventList.DataBind()
>
> ddlEmployees.DataBind()
>
> txtStartDate.Text = calStartDate.SelectedDate.ToShortDateString
>
> txtEndDate.Text = calEndDate.SelectedDate.ToShortDateString
>
> End If
>
> End Sub
>
> Private Sub calStartDate_SelectionChanged(ByVal sender As Object, ByVal e

As

> System.EventArgs) Handles calStartDate.SelectionChanged
>
> txtStartDate.Text = calStartDate.SelectedDate.ToShortDateString
>
> End Sub
>
> Private Sub calEndDate_SelectionChanged(ByVal sender As Object, ByVal e As
> System.EventArgs) Handles calEndDate.SelectionChanged
>
> txtEndDate.Text = calEndDate.SelectedDate.ToShortDateString
>
>