I am trying to figure out why this service does not return any data. The service does not error out is just doesn't return any data. When I take the Linq into LinqPad the query returns exactly as I expect. So I am wondering if the problem is getting my return data into a List<string>??
[Code]....
I don't know what else to say to help. When I set a break point on the "return LoanStats" line a quick watch shows an empty results view.
When stepping through my LINQ query it returns dataq,but when I try to return it as Json Result,I get the error 'The query results cannot be enumerated more than once'.
Here is my LINQ and stored proc,
[Code]...
I'm looking to translate an SQL query into linq
INNER JOIN Usrs ON
SAQ.UserId =
Usrs.UserId AND Scan.UserId =
Users.UserId
I'm not sure how to include the "AND" in the LINQ statement.
I'm new to WCF and this is definitely a rookie question. Why does my browser show/return nothing when I type this URL: http://localhost/service.svc/root, using the code below. I was hoping I would see an xml respone like: <double>56.78</double>. service.svc
--------------------------------------------------------------------------------------
<%@ ServiceHost Language="C#" Service="EssentialWCF.StockService" %>
using System;
using System.ServiceModel;
using System.ServiceModel.Web;
[code]...
I want to call .asmx service from jquery
.asmx service will return multiple data from database.
I need to get those data to jquery on client side
and then i need to put each data into their respective textfield on the client side
My ASP.NET MVC web app has a weird issue. In VS debugging mode it works as expected, but when I publish it to dedicated web server (windows 2003, IIS6) a sql query returns previous data even though underlying data was already updated through the same connection. It looks like as if a query returns cached data. What might be the problem?
View 2 RepliesHow can I SELECT second if first SELECT returns nothing?
View 8 Replieshere is my code:
My sql query is returning 2 rows by my repeater is only displaying 1.
[Code]....
I am working with a .net 2.0 asmx webservice (code below)I need to return 4 "items", which will be based on the success of failure of the webservice, and the actual XML imput itself.The Webservice needs to be asyncronous.I have included the code below, but am happy for someone to re-do it as it's been built up on tutorials and examples.At present, I don't believe the async is working, and the returns don't seem to be getting done.I have also built a test harness, and testing, which allows me to send some custom XML and then receive the response.
[Code]....
Harness:
[Code]....
i work with visual studio 2005 and asp net 2.0 and i must to create a webservice who returns a xml as a string
this string must be use by an application java as i know ..
ok i can create the asmx and my web method who run a sql command BUT how i can return a xml as a string ?
I want to use "if statement" in Linq query. How can I do this situation?
For example:
if txtAge.Text=="", I will not use that in Linq Query.
else txtAge.Text!="", I will use that in Linq Query.
i"ve build a small (verry small) test app with a UI and a domain model and i'm able to show all the data from one table but now i wanna create a query so i only get the data i want but i have no idea how to do this. i've created a domain model with a entity class, an abstract and a concrete repository (see code)
[Code]....
namespace winkelketen.domain.Abstract{ public interface IwinkelketenRepository { IQueryable<Winkelketen> Winkelketen { get; } }}
namespace winkelketen.domain.Concrete{ public class SqlWinkelketenRepository : IwinkelketenRepository { private Table<Winkelketen> productsTable; public SqlWinkelketenRepository(string connectionString) { productsTable = (new DataContext(connectionString)).GetTable<Winkelketen>(); } public IQueryable<Winkelketen> Winkelketen { get { return productsTable; } } }}
and then i created a UI with a controller
[Code]....
and a view
[Code]....
could something give me some tips how to do this or how to get started?
I have a web application that uses LINQ-to-SQL. It has a very strange issue, where a LINQ command retrieves the data that is supposed to be returned by another, totally different query that runs in a different thread. What could be the cause of this?
Specifically, a user accesses the application from his machine, opening a certain page. At the same time, another user accesses a different page from his (different) machine. One of the queries throws an exception, while the other returns the data of the first one, which comes from a very different table!
The case is always reproducible, whenever we stress the application with these two users. I've checked but I don't see any shared variables of any kind. What else could the problem be? What should I be looking for?
I have a class library which has my LINQ doc in it. I added a stored procedure and I get the following in my .dbml.layout :
[Code]....
I include a reference to the dll of the class library to my web project and I get an error about value being returned as int where I am trying to put contents into a datalist or similar.
Code in class that calls this SP :
[Code]....
So I switched code to the following in my dbml.layout document :
[Function(Name="dbo.sp_newsSearch")]public IEnumerable<news_search_result> sp_newsSearch([Parameter(DbType="VarChar(200)")] string searchVal){IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), searchVal);return ((IEnumerable<news_search_result>)(result.ReturnValue));}
And included the following in an external file news_search_result.cs
[Code]....
But now I just get nothing returned. Is this wrong way of calling a SP via LINQ? or have I just put the wrong return type on my LINQ class?
I've build a linq query.But i want a random selection so its not always ID : 1,2,3,4,5,6 How can i randomize this var? I like to bind it to a repeater.//TagCloud:
Random rand = new Random();
var tc1 = from i in JumpTide.cms.menu.GetMenuItems(32)
select new
[code]...
[Code]....
[Code]....
currently i am working on wcf...i am adding data through textborex till here is ok. but when i am retriving it from database into grid..but the grid is getting blank...
i am using this query..--page - svc.cs
public List<AddressBook> BindData()
{
DataClasses1DataContext dc = new DataClasses1DataContext();[code]....
select Groupid,GroupName,onorusername from palgroup where groupid in (select distinct Groupid
View 5 RepliesI have a linq to sql entity class in which I declared some DateTime fileds like this:
[Code]....
And this is how I fetch data form repository:
[Code]....
All non DateTime fields are filled properly but all datetimes are null.[Column(DbType = "smalldatetime")]
I've been trying off and on with no success to get VWD-2008 to (deserialize?) a usable object from a PHP SOAP service that returns a serialized associative array (key/value). Client only, BTW I do not have access to change the service itself.
I DO get a response as an XmlNode[] (sample below). I would just shrug and parse the XML manually (shudder) but since all the elements are named "item", "key", or "value", and then they nest in themselves, this will get really hairy. Especially, since there are a bunch of different functions from this same service that I'd like to use, and almost all of them return an associative array.
If I understand this right, the response doesn't deserialize the associative array The HelloWorld test in the WSDL works fine. From what I gather, the SoapFormatter won't deserialize generics. To be truthful, my understanding of processing data at this level in .Net is sketchy and tenuous at best, but I'll do whatever I have to do to get a workable result from this.
In theory, I should be able to use the XmlSerializer to deserialize to an IDictionary Hashtable or the like, but I'm at a loss as to how I would go about doing that. Do I have to intercept the IDE generated SOAP call? Do I have to hack the WSDL? I've even tried writing a custom class to dump the response into just so I can use it, but I've yet to pull it off, and I've got more than one or two of these to do. I've hit forum after forum and have not found where anyone has give a successful answer to this recurring issue.
The really irritating part is that it is only 3 lines of code in PHP to declare, call, and consume the service to get a usable object and I'm giving myself fits to do it in C#. It CAN'T be THIS hard to do it!
Basic format is the Java Hashtable here:
http://www.ibm.com/developerworks/webservices/library/ws-soapmap1/
XML Node array response:
[Code]....
I'm working with a webservice call after doing
[Code]....
[Code]....
Some strange problem have occured while developing application. Some WCF webservice returns object with date property.On client this web service is called using Jquery.ajax.Then result is parsed using json2.For date I simply use following expressions:
var reMsAjax = /^/Date((d|-|.*))[/|\]$/;
a = reMsAjax.exec(value);
if (a)
var b = a[1].split(/[-+,.]/);
return new Date(b[0] ? +b[0] : 0 - +b[1]);
unfortunatelly if browser timezone differs simple new Date with milliseconds not works.Time will be based on timezone.
I have a web application in ASP.NET 4.0. I've added an asmx service, primarily as a source for the autocomplete extender's lookup values.
When I debug on my machine locally, everything works fine. However, when I deploy the web application to IIS 7.5, I get a HTTP 404 response when trying to send data to the service.
I am able to browse to the service definition, see the available operations. Tellingly, however, when I use the test pages to test the service using POST, I receive an HTTP 404 again.
I'm not sure what is going on. I did create the asmx file within my web application and it is deployed in the virtual directory of my otherwise working production application. Is there an issue with the .asmx file being deployed in the same virtual directory, perhaps?
We have a problem regarding webservices when it runs in https. it say's that the service is undefined. BUT when we try it in http it runs okay...
View 1 RepliesI've created a script that adds user data to a database, however, I'd like to check the email entered is unique within the database.
I've already started the query at comm2 but not sure how to progress the script so it tells the user if the email address is already taken.
[code]....