1) How to create DB Connection in runtime for MYSQL & SQLserver.
2) webschedulersqlclientprovider & webscheduleOleDbProvider is not supporting SqlDataSource & MYSQLDataSource.
3) How to give DataSourceID in Runtime for the webschedulersqlclientprovider & webscheduleOleDbProvider.
4) As we tried from design page it is getting the following errors.,
Code in ASPX Page
<
igsch:WebScheduleInfo ID="WebScheduleInfo1" runat="server"></igsch:WebScheduleInfo>
<igsch:WebMonthView ID="WebMonthView1" runat="server" WebScheduleInfoID
="WebScheduleInfo1"Style="top: 0px; left: 0px"></igsch:WebMonthView>
<ig_scheduledata:WebScheduleSqlClientProvider ID="WebScheduleOleDbProvider1" runat
="server"WebScheduleInfoID="WebScheduleInfo1" DataSourceID="SqlDataSource1">
</ig_scheduledata:WebScheduleSqlClientProvider>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:webschedule2ConnectionString2 %>
"SelectCommand="SELECT * FROM activity" DataSourceMode="DataReader"></asp:SqlDataSource>
ERROR IS AS FOLLOW
5) we tried by using OLEDB Provider, we are gettigthe following error.
<igsch:WebScheduleInfo ID="WebScheduleInfo2" runat="server"></igsch:WebScheduleInfo>
<igsch:WebMonthView ID="WebMonthView2" runat="server" WebScheduleInfoID
<ig_scheduledata:WebScheduleOleDbProvider ID="WebScheduleOleDbProvider1" runat
="server"WebScheduleInfoID="WebScheduleInfo1" DataSourceID="MySqlDataSource1">
</ig_scheduledata:WebScheduleOleDbProvider>
<cc2:MySqlDataSource ID="MySqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:webschedule2ConnectionString2 %>
"SelectCommand="SELECT * FROM activity"></cc2:MySqlDataSource>
ERROR IS
DataSourceID indicates a data source control of type 'Devart.Data.MySql.Web.MySqlDataSource' which is incompatible with the WebSchedule database provider. The data source control must be derived from type 'SqlDataSource'.
Hi,
I am following up with you regarding this forum post and if you would like to discuss it further.
Magued
We recommend using a Generic Data Provider. Please refer to the following link for more information:
https://es.infragistics.com/help/aspnet/webschedulegenericdataprovider-webschedulegenericdataprovider
https://es.infragistics.com/help/aspnet/webschedule-data-model-for-webschedule-generic-data-provider
Please send me regarding any questions.
I had created CustomDataProvider and am not able to connect with MYSQL DataBase...
Was the issue resolved? If not then please update the forum post regarding any questions.
Please refer to the following link on implementing a customer data provider:
https://es.infragistics.com/community/forums/f/ultimate-ui-for-asp-net/61506/help-required-in-sorting-amount-currency-field-in-ultraweb-grid
The link contains a link to Knowledge Base Article 8484 on How to connect a WebSchedule to a custom data source.