I am also having difficulty figuring out how to customize the stored procedure names used by the WebScheduleSqlClientProvider.  Maybe by posting what we have so far, we can cooperatively figure this out.  I basically just started the new class to inherit off of the WebScheduleSQLClientProvider and checked the intellisense that shows up when you type Public Overrides or Protected Overrides. 

Description:
I have the following code where I attempt to override the field names returned from the stored procedure in the DB.  I used the DDL scripts provided with the SQL sample and then modified the names of the stored procedures and the table field names to match with our database naming scheme policy.  It looks like changing the returned field names would be easy by implementing something like that below.  I can't find any exposed properties that would allow me to change the stored procedure names though.  Can you point me in the correct direction or provide a sample code snippet showing how to change one?  

As an example, I've changed the activity fetch procedure from dbo.Activity_Sel to dbo.spCalendarActivity_Sel


EXAMPLE CODE
Imports Microsoft.VisualBasic
Imports Infragistics.WebUI.Data

Public Class LSIWebScheduleSQLProvider
    Inherits WebScheduleSqlClientProvider

    Protected Overrides Function InitializeAppointmentBindings(ByVal defaultBinding As Infragistics.WebUI.Data.AppointmentBinding) As Infragistics.WebUI.Data.AppointmentBinding
        With defaultBinding
            .SubjectMember = "vchSubject"
            .StatusMember = "bitStatus"
            .DurationMember = "intDuration"

        End With

        Return MyBase.InitializeAppointmentBindings(defaultBinding)
    End Function
End Class

tbird said:

This is unacceptable and we will migrate to a better tool that provides simple dynamic databinding for the elements we choose to use. 

Hi

Could you name this tool?

Thank you a lot for help.

Andriy Zhornyk

I must say this is a pathetic model.  We have a complex sql database and utilize the windows dayview and bind to our data model easily.  Now, as we look at the web your tool requres we either re-tool our model to fit yours or attempt to create a lot of code behind to mimic your anticipated data model.  This is unacceptable and we will migrate to a better tool that provides simple dynamic databinding for the elements we choose to use.  Please let us know if you decide to change this model in the future as it may allow us to use your tools for our web side development.

Ok, we can´t modify the parameters in the Stored Procedures, so, if we need to use a more complex query with more parameters we need to use a SQLDataSource with UseStoredProcedures = False, but than returns an error "isnull function requires at least 2 arguments". Do you have any idea or samples on using "UseStoredProcedures = False"?

 Thanks

Hi I got it connected to the database. I used the following code to connect it.

private void InitializeComponent()
        {
            this.WebScheduleSqlClientProvider1 = new Infragistics.WebUI.Data.WebScheduleSqlClientProvider();
            WebScheduleSqlClientProvider1.DataSourceID = "SqlDataSource1";           
            SqlDataSource1.ProviderName = "System.Data.SqlClient";
            SqlDataSource1.ConnectionString = ConfigurationManager.AppSettings["Connection1"] + Session["databasename1"].ToString();
        }

I am getting error when trying to set the sqldatasource connectionstring property at run-time. I use different databases and need to assign the connection accordingly. I am using ASP.NET 2.0, SQL Server 2005 and Infragistics v 8.1 and have the following code working.

                                     <igsch:WebScheduleInfo ID="WebScheduleInfo1" EnableSmartCallbacks="true" runat="server"
                                        EnableRecurringActivities="True"

OnActiveDayChanging="WebScheduleInfo1_ActiveDayChanging">
                                      <ClientEvents  ActivityUpdating="WebScheduleInfo1_ActivityUpdating"
             ActivityAdding="WebScheduleInfo1_ActivityAdding" />
                                    </igsch:WebScheduleInfo>
                                    <ig_scheduledata:WebScheduleSqlClientProvider ID="WebScheduleSqlClientProvider1"
                                        runat="server" DataSourceID="SqlDataSource1" WebScheduleInfoID="WebScheduleInfo1">
                                    </ig_scheduledata:WebScheduleSqlClientProvider>
                                    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
                                    ConnectionString="<%$ ConnectionStrings:EMO_ConnectionString %>"
                                        SelectCommandType="StoredProcedure" SelectCommand="Activity_Sel">
                                        <SelectParameters>
                                            <asp:SessionParameter Name="ResourceName" SessionField="ResourceName" Type="String" />
                                        </SelectParameters>
                                    </asp:SqlDataSource>

 but when I assign it in run-time in Page_Load(),

  SqlDataSource1.ProviderName = "System.Data.SqlClient";
  SqlDataSource1.ConnectionString = ConfigurationManager.AppSettings["Connection1"] + Session["databasename1"].ToString();

it shows the following error and I don't have a database named WebSchedule1.

Cannot open database requested in login 'WebSchedule1'. Login fails.
Login failed for user 'sa'.

Can anybody help me...