Guest User

Untitled

a guest
Jun 19th, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.65 KB | None | 0 0
  1. MyDataSource.SelectParameters["startDate"].DefaultValue =
  2. fromDate.SelectedDate.Date.ToString();
  3.  
  4. <asp:SqlDataSource ID="MyDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:sampledb %>" SelectCommand="Recording_Select" SelectCommandType="StoredProcedure" OnSelecting="MyDataSource_Selecting">
  5. <SelectParameters>
  6. <asp:ControlParameter ControlID="respondentID" DefaultValue="%" Name="RespondentID" PropertyName="Text" Type="String" />
  7. <asp:SessionParameter Name="projectCode" SessionField="proj" Type="String" />
  8. <asp:ControlParameter ControlID="interviewerList" Name="InterviewerID" PropertyName="SelectedValue" Type="String" />
  9. <asp:ControlParameter ControlID="dispCodeList" Name="dispCode" PropertyName="SelectedValue" Type="Int32" />
  10. <asp:ControlParameter ControlID="fromDate" DefaultValue="1/1/1900" Name="startDate" PropertyName="SelectedValue" Type="DateTime" />
  11. <asp:ControlParameter ControlID="toDate" DefaultValue="1/1/1900" Name="endDate" PropertyName="SelectedValue" Type="DateTime" />
  12. </SelectParameters>
  13. </asp:SqlDataSource>
  14.  
  15. DateTime DotNetDateTime = new DateTime(2009, 5, 4);
  16. System.Data.SqlTypes.SqlDateTime sqlDateTime = new System.Data.SqlTypes.SqlDateTime(DotNetDateTime);
  17.  
  18. System.Data.SqlTypes.SqlDateTime sqlDateTime = new System.Data.SqlTypes.SqlDateTime(2009, 5, 4);
  19.  
  20. MyDataSource.SelectParameters["startDate"].DefaultValue =
  21. fromDate.SelectedDate.Date.ToString("yyyyMMdd HH:mm:ss");
  22.  
  23. MyDataSource.SelectParameters["startDate"].DefaultValue = fromDate.SelectedDate.Date.ToString("yyyy-MM-dd HH:mm:ss")
Add Comment
Please, Sign In to add comment