Forums Ultimate UI for ASP.NET Web Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
sri
810
connect to sql server
posted

Hello,

 

How can I use genericdataprovider to connect to the sql server and use my stored procedures.Should I have to build the tables Resources,Activity etc. where can I find the scripts for those.

Any link to start with will help.

Thanks

  • 24671
    posted

    Hi,

    You are probably confusing the Generic provider with the SQL Provider. The SQL WebSchedule provider relies on a very specific schema, and that's why we ship stored procedures and SQL scripts in the actual installation, which you run and it builds the above tables for you.

    With the generic Data Provider, you don't need to be tied to any schema, the important thing is to define the mappings between Appointment / Resource properties, and actual Data Store. You can bind to DataSet, IEnumerable, SQL, ObjectDataSource, etc. Here are some examples to get you started:

    http://help.infragistics.com/NetAdvantage/ASPNET/2010.3/CLR4.0/?page=WebSchedule_WebScheduleGenericDataProvider_CRUD_Statements_for_SQL_Data_Source.html

    http://help.infragistics.com/Help/NetAdvantage/ASPNET/2010.3/CLR4.0/HTML/WebScheduleGenericDataProvider_About_WebScheduleGenericDataProvider.html

     

    Thanks,

    Angel