open a gridview of specific date using calendar

Sulieman Alkatib

9y1.4k.NET

I have problem to extract attendance information of selected date on calendar so I make a triky code which assign selected date from calendar to a textbox and then a gridview should appear that have a column value = textbox value or something like this

Public Class Attendance
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Calendar1.Visible = False
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
Calendar1.Visible = True
End Sub
Protected Sub Calendar1_SelectionChanged(ByVal sender As Object, ByVal e As EventArgs) Handles Calendar1.SelectionChanged
TextBox1.Text = Calendar1.SelectedDate
End Sub
End Class

"GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource2" EnableModelValidation="True">
"EID" HeaderText="EID" SortExpression="EID" />
"DateOfDay" HeaderText="DateOfDay"
SortExpression="DateOfDay" />
"Present" HeaderText="Present"
SortExpression="Present" />

so now I need to filter the result of gridview by selected date

thanks developers

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Chetan Ranpariya9y ago
Accepted answer
Query should look like
var selectedDate = Calender.SelectedDate;

var queryString = "SELECT * FROM {tableName} WHERE {columnName} = @selectedDate";
var cmd = new SqlCommand(queryString);
cmd.Parameters.Add(new SqlParameter("@selectedDate", selectedDate);
I do not know the tablename and columnname of your database so I have put placeholders. You put proper values there.
Run this command with SQLConnection object and retrieve data and bind it to gridview.

Thanks and regards,
Chetan Ranpariya
Sulieman Alkatib9y ago
thank you @Chetan
Sulieman Alkatib9y ago
partally I understand your idea but can you provide coding to run that query?
Chetan Ranpariya9y ago
Hi,

Instead of filtering the data inside the gridview, you should query the fresh data from the database based on the date selected and rebind your gridview.

Thanks and regards,
Chetan Ranpariya