Intersoft Community - WebScheduler - WebScheduler 3-Binding to SQL database step 18

WebScheduler 3-Binding to SQL database step 18

yudi — Tue, 02 Mar 2010 20:25:15 GMT

Thank you for the constructive criticism.
I have informed this to Documentation team to be fixed. The fix will be included in the next installer file of Intersoft WebUI Studio.

Please feel free to contact us with any questions or concerns you may have.

WebScheduler 3-Binding to SQL database step 18

roamerz — Tue, 02 Mar 2010 15:46:01 GMT

Could you please update the walkthrough with the correct information. It would sure save people some valuable time and perhaps influence their purchasing decision in a positive manner. I ran into this same issue while trying to evaluate the product.

Thanks

WebScheduler 3-Binding to SQL database step 18

yudi — Mon, 01 Mar 2010 04:57:58 GMT

On step #16: Add a new class and named it Intersoft_DataSet.cs.

On step #17: Here is the Intersoft_DataSet.cs’s content.

Inside the Intersoft_DataSet.cs class code, please modify following line.

Line 2:

Original code: namespace IntersoftDataSetTableAdapters

Change to: namespace Intersoft_DataSetTableAdapters

Line 14; 37; 60; 83; 106:

Original code: OleDbCommand command = new OleDbCommand();

Change to: SqlCommand command = new SqlCommand();

Line 17; 40; 63; 86; 109:

Original code: return (int)command.ExecuteScalar();

Change to: return int.Parse(command.ExecuteScalar().ToString());

If the error still persists, could you please kindly send the complete project for further investigation?

WebScheduler 3-Binding to SQL database step 18

fgary6861 — Sat, 27 Feb 2010 17:17:35 GMT

Ok the previous sql server post has been resolved it was simply a setting in vs2008 causing the problem. so now everything is almost ok. I have replicated the movies project and built with no errors.

However, when I try to run the project in vs2008 the page loads with a blank white page and I noticed the webscheduler_movies.mdf sql database file keeps closing the server connection as soon as the page loads.

Help please.......I think I am close!

WebScheduler 3-Binding to SQL database step 18

fgary6861 — Sat, 27 Feb 2010 16:44:51 GMT

Hi, as a followup to my previous post, I think I almost have this figured out by pretty much duplicating the movies project code. However, I am getting database errors regarding sql server to the effect that I am using version 655 and the webscheduler/isdatasurce only supports version 612 and lower with no downgrade path.

I am using sql server full 2008 x64 with sp1 as follows:

Microsoft SQL Server Management Studio      10.0.2531.0
Microsoft Analysis Services Client Tools      10.0.1600.22
Microsoft Data Access Components (MDAC)      6.1.7600.16385
Microsoft MSXML      3.0 4.0 5.0 6.0
Microsoft Internet Explorer      8.0.7600.16385
Microsoft .NET Framework      2.0.50727.4927
Operating System      6.1.7600

is this sql version "to new"? If so, what is the nearest "downgraded" version I can use. Can I use sql server full version at all?

I have spent 4 days trying to get a simple webscheduler application to simply load in a browser and am getting really frustrated trying to evaluate this product.

WebScheduler 3-Binding to SQL database step 18

fgary6861 — Sat, 27 Feb 2010 14:36:56 GMT

Hi, could you be more specific as to how to use the dsSchedulerMoviesSql.cs? I am getting the exact same 30 error messages as posted here by Kevin. I have tried cutting and pasting the c# code from dsSchedulerMoviesSql.cs to the IntersoftDataSet.cs file as outlined in the walkthrough but I still get 20 error messages.

Are there other steps I need to do? Please help and thanks

WebScheduler 3-Binding to SQL database step 18

Krschauder — Fri, 26 Feb 2010 02:48:26 GMT

Thank you. Got it to work!

WebScheduler 3-Binding to SQL database step 18

yudi — Thu, 25 Feb 2010 02:11:18 GMT

From your sent screenshot, it seems that the “this” refer to wrong object/class. You may check “dsSchedulerMoviesSQL.cs” inside ‘App_Code’ folder of WebSchedulerSamples project as the sample reference. The sample also shows about how to bind SQL database to WebScheduler uses ISDataSource.

Look forward for your response.

WebScheduler 3-Binding to SQL database step 18

Krschauder — Tue, 23 Feb 2010 21:49:23 GMT

I am currently trying to do the walkthrough of binding a SQL database to Webscheduler using ISDataSource. On step 18. Build the Solution, I get the attached errors. It is complaining on the this.Connection line.