Hi guys,
i would like to know how to Filter selected date from calendar to display chart reading from database using web application from visual studio aspx page
Is there a way to do it?
i would like to know how to Filter selected date from calendar to display chart reading from database using web application from visual studio aspx page
Is there a way to do it?
You could use JQuery DatePicker or Asp.net Calendars control to selected date. Please refer to the following links:
Then, refer to the following code to filter data from database:
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
using (SqlCommand com = new SqlCommand("SELECT * from table where [Date] between @SD and @ED", con))
{
com.Parameters.AddWithValue("@SD", txtfromDate.Text);
com.Parameters.AddWithValue("@ED", txttodate.Text);
using (SqlDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
int id = (int) reader["iD"];
string desc = (string) reader["description"];
Console.WriteLine("ID: {0}\n {1}", iD, desc);
}
}
}
}
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
using (SqlCommand com = new SqlCommand("SELECT * from table where [Date] between @SD and @ED", con))
{
com.Parameters.AddWithValue("@SD", txtfromDate.Text);
com.Parameters.AddWithValue("@ED", txttodate.Text);
using (SqlDataReader reader = com.ExecuteReader())
Member
6 Points
50 Posts
Filter selected date from calendar to display chart reading from database
Mar 24, 2017 08:19 AM|JovanYong|LINK
Hi guys,
i would like to know how to Filter selected date from calendar to display chart reading from database using web application from visual studio aspx page
Is there a way to do it?
All-Star
45431 Points
7008 Posts
Microsoft
Re: Filter selected date from calendar to display chart reading from database
Mar 25, 2017 03:27 AM|Zhi Lv - MSFT|LINK
Hi JovanYong,
You could use JQuery DatePicker or Asp.net Calendars control to selected date. Please refer to the following links:
https://jqueryui.com/datepicker/
https://www.tutorialspoint.com/asp.net/asp.net_calenders.htm
Then, refer to the following code to filter data from database:
using (SqlConnection con = new SqlConnection(strConnect)) { con.Open(); using (SqlCommand com = new SqlCommand("SELECT * from table where [Date] between @SD and @ED", con)) { com.Parameters.AddWithValue("@SD", txtfromDate.Text); com.Parameters.AddWithValue("@ED", txttodate.Text); using (SqlDataReader reader = com.ExecuteReader()) { while (reader.Read()) { int id = (int) reader["iD"]; string desc = (string) reader["description"]; Console.WriteLine("ID: {0}\n {1}", iD, desc); } } } }More details, see:
https://www.codeproject.com/Questions/556502/Howplustoplussearchplusaplusrecordplusfromplusdata
Finally, refer to the following links to create a chart.
https://www.aspsnippets.com/Articles/Create-ASPNet-Chart-Control-from-Database-using-C-and-VBNet-Example.aspx
Best regards,
Dillion
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
Member
6 Points
50 Posts
Re: Filter selected date from calendar to display chart reading from database
Mar 28, 2017 01:28 AM|JovanYong|LINK
Where does your strConnect leads to?
using (SqlConnection con = new SqlConnection(strConnect)) { con.Open(); using (SqlCommand com = new SqlCommand("SELECT * from table where [Date] between @SD and @ED", con)) { com.Parameters.AddWithValue("@SD", txtfromDate.Text); com.Parameters.AddWithValue("@ED", txttodate.Text); using (SqlDataReader reader = com.ExecuteReader())
Member
6 Points
50 Posts
Re: Filter selected date from calendar to display chart reading from database
Mar 28, 2017 01:49 AM|JovanYong|LINK
Thanks alot! You help me alot (: !!!!!!