hello - trying to work out webdayview control. I have the following in my markup:
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:SqlDataSource ID="rs_Scheduled_Information" runat="server"
ConnectionString="<%$ ConnectionStrings:myconnection %>"
SelectCommand="SELECT iwre.requestNumber,
iwre.ApptStart,
iwre.ApptEnd,
iwre.ApptSubject,
ir.FirstName,
ir.LastName
FROM dbo.Inspection_WorkRequest_Ext iwre
INNER JOIN dbo.Inspection_Resource ir ON iwre.ApptResourceID = ir.ResourceID
where ir.ResourceID = @ResourceID"
SelectCommandType="Text" >
<SelectParameters>
<asp:QueryStringParameter Name="ResourceID" QueryStringField="ResourceID" />
</SelectParameters>
</asp:SqlDataSource>
<ig_scheduledata:WebScheduleSqlClientProvider ID="WebScheduleSqlClientProvider1" DataSourceID="rs_Scheduled_Information"
runat="server" WebScheduleInfoID="WebScheduleInfo1" StyleSetName=""
StyleSetPath="" StyleSheetDirectory="">
</ig_scheduledata:WebScheduleSqlClientProvider>
<igsch:WebDayView ID="WebDayView1" runat="server" VisibleDays="5" Width="80%"
WebScheduleInfoID="WebScheduleInfo1" EnableMultiResourceCaption="True"
MultiDayEventFromArrowCaption="" MultiDayEventToArrowCaption="" StyleSetName=""
StyleSetPath="" StyleSheetDirectory="" >
</igsch:WebDayView>
<igsch:WebScheduleInfo ID="WebScheduleInfo1" runat="server" StyleSetName=""
StyleSetPath="" StyleSheetDirectory="" WeekRule="FirstFullWeek">
</igsch:WebScheduleInfo>
Not sure what to do next. I guess I need to tell one of the controls how to use my sqldatasource? but i am not sure which one. if someone can point me to a detailed example - that would help. Pretty new to the infragistics controls. So any hlep would be appreciated. Sorry in advance for this simple question! also, I would like the 5 day calendar to always display from Monday - no matter what day of the week it is.
Hello hlucky,
Thank you for posting in the community.
The sql provider requires certain database schema to be present if you want to bind your database automatically to SQL. Some further reference may be found at:
http://ko.infragistics.com/community/forums/t/24464.aspx
Additionally, an example of databindg WebMonthView to DataSet is available at:
http://ko.infragistics.com/products/aspnet/sample/schedule/bind-genericdataprovider-to-dataset
Hope this helped. Feel free to contact me if you have any additional questions.
I am still following your case, have you been able to resolve you issue? If you need any futher support do not hesitate to contact me.
i am still confused. i guess this is above my pay-grade! anyhow - i have a custom data source:
ConnectionString="<%$ ConnectionStrings:CustomQuoteConnectionString %>"
and a generic data provider:
<ig_scheduledata:WebScheduleGenericDataProvider ID="WebScheduleGenericDataProvider1"
runat="server" ActivityDataSourceID="rs_Scheduled_Information" StyleSetName=""
StyleSetPath="" StyleSheetDirectory="" WebScheduleInfoID="WebScheduleInfo1">
</ig_scheduledata:WebScheduleGenericDataProvider>
which I think uses the SQLDataSource record set. So if that is all correct - how do i "tell" the webdayview about my specific data types as defined in the sqldatasource:
iwre.requestNumber,
Thanks.
The dataprovider can be configured using data coming from a different schema as long as the relevant bindings are configured. Some further reference may be found at:
http://help.infragistics.com/NetAdvantage/ASPNET/2012.2/CLR4.0/?page=WebSchedule_WebScheduleGenericDataProvider_CRUD_Statements_for_SQL_Data_Source.html
Do not hesitate to contact me if you need any additional support.
Feel free to contact me if you have any additional questions regarding this matter.