Scheduled Call To Web Service - C# Discussion Boards

21-Dec-06 3:13

Hello,

I would like to make a call to a web service at regular intervals and I'm interested in opinions on how best to do it.

My web service will need to read in some data from a database and move it to another application. This needs to happen for one case every 10 minutes, another case every hour and another case every 24 hours.

The easiest method I think is to use the built-in Windows Task Scheduler service as I've read somewhere that a Windows service would probably be overkill for what I want to do - the web service can report success if it is called so there's no need to audit the Windows Task Scheduler (I understand that there are potential problems with relying on the WTS to report errors).

The WTS seems a bit of a poor cousin of UNIX/Linux's cron. I wonder why MS has never bothered turning it into something actually useful?

So, can anyone tell me how to:

1. Add a job to the WTS which will call a web service (how do I call a web service on the command line)?

2. Implement something better - can I implement something in the web service itself or should I just write a separate service for each process that needs to call my service.

Thanks Smile | :)

Eduard Keilholz21-Dec-06 3:31

Eduard Keilholz

21-Dec-06 3:31

Erhm, there are several issues you're talking about. For example, you say the webservice can report whether your process was succesfull. In fact, the webservice can only report that the webservice process went succesfull. It did send the data to your app. The webservice cannot report whether the parsing of that data on your 'local' machine was succesfull.

Second, you cannot start a webservice from the commandline. You need to develop an app. which has a reference to the webservice and invoke a method within the webservice. You should schedule your app calling, and make you app report if something went wrong (and what) or (which is what we aim for) everything went fine.

I think you can schedule you app. using WTS don't think you'll run into problems there.

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

Member 361802521-Dec-06 3:56

21-Dec-06 3:56

thx for the reply.

The web service will exist on the same machine as the database and the application so no problem there Smile | :)

I don't want to start the web service from the command line, I just want to call a method on the web service. I did find this though which seems to work well:

Save the following as MSFT.vbs:

set SOAPClient = createobject("MSSOAP.SOAPClient")
SOAPClient.mssoapinit "http://www.webservicex.net/stockquote.asmx?WSDL"
WScript.Echo "MSFT = " & SOAPClient.GetQuote("MSFT")

Then from a command prompt, run: 

C:\>MSFT.vbs

I just have to verify it working under WTS now Smile | :)

Pete O'Hanlon21-Dec-06 3:35

Pete O'Hanlon

21-Dec-06 3:35

If you are using SQL Server, you should consider using DTS/SSIS instead. These have been designed to do exactly what you have stated. A web-service gives you no benefit, and requires a lot of extra work that is taken care of by SQL Server.

the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer

Deja View - the feeling that you've seen this post before.

Member 361802521-Dec-06 3:59

21-Dec-06 3:59

Thx, my fault for not being clearer - when I say reading data from a database I'm actually calling another web service (from my web service) which provides the data from a crm system. Totally agree about DTS if it were just a SQL server of course Smile | :)

Pete O'Hanlon21-Dec-06 4:38

Pete O'Hanlon

21-Dec-06 4:38

If you've got SQL Server 2005, then you could still do this. Bear in mind that you can host CLR applications inside SQL Server, so you would still be able to leverage this.

Member 361802521-Dec-06 4:14

retrieve selectedvalues from checkedlistbox ion .net 2.0

21-Dec-06 4:14

My apologies to Mexicans by the way for the screen name - it's a temporary one I got from bugmenot.com and I didn't realise it could be construed as being offensive. I'm on site at the moment and haven't got my proper details Frown | :(

fmardani21-Dec-06 3:08

fmardani

21-Dec-06 3:08

This is how a checkedlistcontrol is populated:

chklstUserRoles.DataSource = dsUsersAndRoles.Tables["Roles"].DefaultView;
chklstUserRoles.DisplayMember = "Name";
chklstUserRoles.ValueMember = "RoleID";

I would like to loop through a checkedlistBox control and collect the IDs that is allocated to each checked item in the control.

This does not quite work:
for (int i = 0; i <= chklstUserRoles.CheckedItems.Count - 1; i++)
{
strRoleIds += chklstUserRoles.SelectedValue.ToString() + ",";
//strRoleIds += chklstUserRoles.CheckedItems[i].ToString() + ",";
}

Thanks

Network share ?

Vertyg021-Dec-06 2:51

Vertyg0

21-Dec-06 2:51

How to check if network share requires authentication from me using WMI or any other way ?

Thanks.

Re: Network share ?

Dave Kreskowiak21-Dec-06 4:55

Dave Kreskowiak

21-Dec-06 4:55

The only way to tell is to try and access it. If it fails, then you need to authenticate to the target server.
WMI won't help you in this case.

Dave Kreskowiak
Microsoft MVP - Visual Basic

C1webgrid binding issue

paul (the power) carey21-Dec-06 2:45

paul (the power) carey

21-Dec-06 2:45

I'm trying to find out how to bind an Itemtemplate which is dropdown ascx control to another data bound column in a webgrid.

I have this:

************************************************************
Diary di = Diary.GetDiaryItem(d);

grdDiary.DataSource =di.DiaryHistory;

C1.Web.C1WebGrid.C1BoundColumn col1 = new C1.Web.C1WebGrid.C1BoundColumn();
col1.DataField="DiaryEvent";
grdDiary.Columns.Add(col1);

C1.Web.C1WebGrid.C1TemplateColumn col2 = new C1.Web.C1WebGrid.C1TemplateColumn();
col2.ItemTemplate = LoadTemplate(@"Modules\EventCtl.ascx");
grdDiary.Columns.Add(col2);

grdDiary.DataBind();
**************************************************************

col2(dropdown) needs to reflect col1

Any help would be gratefully received!!

When to use new while creating object.

Nitin198121-Dec-06 1:47

Nitin1981

21-Dec-06 1:47

Hi all! Please clarify my one doubt regarding new operator. When it is needed to use new while creating an object.

Don't Quit

J4amieC21-Dec-06 2:02

J4amieC

21-Dec-06 2:02

Nitin1981 wrote:
When it is needed to use new while creating an object.

always.

---

How to get answers to your questions[^]

Nitin198121-Dec-06 2:13

Nitin1981

21-Dec-06 2:13

Hi J4amie C! Thanks for reply. Please clarify few doubts.

1. Is it necessary to be used with reference types only?

If so why DataReader can be used without new.

2. If value types dont reuire a new then

Why in windows forms it is used like this?. where point(it is a structure) is a value type.

Form1.location = new System.Drawing.Point(x,y);

Regards

Don't Quit

Colin Angus Mackay21-Dec-06 2:26

Colin Angus Mackay

21-Dec-06 2:26

Nitin1981 wrote:
If so why DataReader can be used without new

It can't. It is just the new data reader is instantiated inside the ExecuteDataReader method rather than in YOUR code.

Nitin1981 wrote:
If value types dont reuire a new then

Value types require a new. You might be getting confused with primative types (e.g. 1, true, 3.1415, "some string") which also happen to be mostly value types (strings are reference types)

Upcoming Scottish Developers events:
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Guffa21-Dec-06 2:42

Guffa

21-Dec-06 2:42

Nitin1981 wrote:
1. Is it necessary to be used with reference types only?

Yes. If it's not a reference type, then it doesn't handle an object.

Nitin1981 wrote:
If so why DataReader can be used without new.

It can't. But it's not you who create the DataReader, so it's not needed in your code.

Nitin1981 wrote:
Why in windows forms it is used like this?. where point(it is a structure) is a value type.

Form1.location = new System.Drawing.Point(x,y);

A value type may have a constructor, but it will not create an object, it will just return a new value. A value type also always has a parameterless constructor, that returns a value where all members are zero.

A value type declared as a member of a class will be initialized to zero when an object of the class is created. A value type declared as a local variable in a method will be undefined, and the compiler won't let you use it before you have assigned a value to it.

---
It's amazing to see how much work some people will go through just to avoid a little bit of work.

Pete O'Hanlon21-Dec-06 2:43

Pete O'Hanlon

21-Dec-06 2:43

Nitin1981 wrote:
If so why DataReader can be used without new.

It is common practice to provide a method that instantiates an object and returns it to you without requiring you to do anything to create it. ExecuteDataReader internally creates a DataReader and returns an instantiated version to you.