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'.
These errors are expected.
WebScheduleSqlClientDataProvider makes use of SqlConnection and supports only Microsoft SQL Server 2005 and up.
WebScheduleOleDbDataProvider makes use of OleDbConnection and supports only Microsoft Access / Jet databases. MySQL is not supported by either of these data providers.
You will need to either write a custom data provider that implements IDataFetch and IDataUpdate, or you may be able to use the WebScheduleGenericDataProvider (you would still have to provide the data access logic).
I tried by creating custom data provider but am not able to do get that.
please can u send one sample of custom data provider that connects to MYSQL & WebScheduleInfo...
Hi,
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.
Magued
Was the issue resolved? If not then please update the forum post regarding any questions.
I am following up with you regarding this forum post and if you would like to discuss it further.
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...