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

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

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

="WebScheduleInfo1"Style="top: 0px; left: 0px"></igsch:WebMonthView>

<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'.