Guest User

Untitled

a guest
Jun 22nd, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.45 KB | None | 0 0
  1. public string GetFirstofMonth(DateTime dt)
  2. {
  3. int thisMonth = dt.Month;
  4. int thisYear = dt.Year;
  5. string firstOfMonth = thisMonth.ToString() + "/1/" + thisYear.ToString();
  6. return firstOfMonth;
  7. }
  8.  
  9. public string GetLastofMonth(DateTime dt)
  10. {
  11. DateTime Date2Obj = new DateTime(dt.Year, dt.Month, 1);
  12. int thisMonth = dt.Month;
  13. int thisYear = dt.Year;
  14. Date2Obj.AddMonths(1);
  15. Date2Obj.AddDays(-1);
  16. int lastDay = Date2Obj.Day;
  17. string LastOfMonth = thisMonth + "/" + lastDay + "/" + thisYear;
  18. return LastOfMonth;
  19. }
  20.  
  21. <asp:SqlDataSource ID="SqlDataSource1" runat="server"
  22. ConnectionString="<%$ ConnectionStrings:MeetingsConnectionString %>"
  23. SelectCommand="SELECT * FROM [Events] WHERE (([EventDate] >= @EventDate) AND ([EventDate] <= @EventDate2))">
  24. <SelectParameters>
  25. <asp:Parameter DbType="Date" Name="EventDate" />
  26. <asp:Parameter DbType="Date" Name="EventDate2" />
  27. </SelectParameters>
  28. </asp:SqlDataSource>
  29.  
  30. <asp:SqlDataSource ID="SqlDataSource1" runat="server" OnSelecting="SqlDataSource1_Selecting"
  31. ConnectionString="<%$ ConnectionStrings:MeetingsConnectionString %>"
  32. SelectCommand="SELECT * FROM [Events] WHERE [EventDate] BETWEEN @EventDate AND @EventDate2">
  33. <SelectParameters>
  34. <asp:Parameter Name="EventDate" />
  35. <asp:Parameter Name="EventDate2" />
  36. </SelectParameters>
  37. </asp:SqlDataSource>
  38.  
  39. protected void SqlDataSource1_Selecting(object sender, SqlDataSourceEventArgs e)
  40. {
  41. e.Command.Parameters["@EventDate"].Value
  42. = GetFirstofMonth(DateTime.Now); //replace with your date param
  43. e.Command.Parameters["@EventDate2"].Value
  44. = GetLastofMonth(DateTime.Now); //replace with your date param
  45. }
  46.  
  47. public void Page_Load( ... )
  48. {
  49. ...
  50. EventDate.Value = GetFirstOfMonth( DateTime.Today );
  51. EventDate2.Value = GetLastOfMonth( DateTime.Today );
  52. ...
  53. }
  54.  
  55. <asp:HiddenField runat="server" id="EventDate" />
  56. <asp:HiddenField runat="server" id="EventDate2" />
  57.  
  58. <asp:SqlDataSource ID="SqlDataSource1" runat="server"
  59. ConnectionString="<%$ ConnectionStrings:MeetingsConnectionString %>"
  60. SelectCommand="SELECT * FROM [Events] WHERE (([EventDate] >= @EventDate) AND ([EventDate] <= @EventDate2))">
  61. <SelectParameters>
  62. <asp:ControlParameter DbType="Date" Name="EventDate" ControlID="EventDate" PropertyName="Value" />
  63. <asp:ControlParameter DbType="Date" Name="EventDate2" ControlID="EventDate2" PropertyName="Value" />
  64. </SelectParameters>
  65. </asp:SqlDataSource>
  66.  
  67. select * from Events where Month(EventDate) = Month(getdate())
Add Comment
Please, Sign In to add comment