I want to create a DataSet in a webservice by connecting to it.On the client side, I will display the Dataset in Crystal Reports.Here is the query I wrote which does not work:

SELECT atm_amount,atm_branch,atm_date,balance FROM ATM_Transactions WHERE user_id=Session["UserId"].ToString()

The query builder gives the error:

Incorrect syntax near "UserId"

Is there any way else I could do it? Please tell me the mehtod and the
way I could do it?

Refer to some tutorials and detailed code with explanations.


we|Rd0

Hi there,

Sessions work with cookies which are problematic by default in stateless web service calls. There are, however, work arounds that allow you to use cookies and thus sessions. A few terms to use in Google:

stateless web service cookie session .NET

This should give you some useful results.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.