WCF / ASMX :: Create A Service To Allow Client Application To Update Their Data

Sep 22, 2010

I want to create a WCF Service to transfer data to our clients application(WPF). The Data I am trying to send is as follows.

ID Code Description unit Rate
1 104200000 LIVE GOAT NOS 25
2 104200000 LIVE GOAT2 NOS 25
3 104200030 LIVE GOAT3 KGS 10
4 104202030 Water LTR 5

and so on till ~ 11000 records.

What I have done so far is. Created a service which return a list of data.

public List<Classes.TariffData> GetTariffData() { var currentTariffData = new List<Classes.TariffData>(); using (var myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)) { const string query = "select a.ID,a.Code,a.Description,a.unit,a.rate,a.rate3 from tariff.dbo.tariffdata a, tariff.dbo.code_history b where a.id = b.id and b.endofvalidity is null"; using (var myCommand = new SqlCommand(query, myConnection)) { using (var ad = new SqlDataAdapter(myCommand)) { var dt = new DataTable("tariff"); ad.Fill(dt); currentTariffData.AddRange(from DataRow row in dt.Rows select new Classes.TariffData { Id = int.Parse(row["Id"].ToString()), Code = row["Code"].ToString(), Description = row["Description"].ToString(), Unit = row["unit"].ToString(), Rate = row["rate"].ToString(), Rate3 = row["rate3"].ToString() }); return currentTariffData; } } } }
Class is as follows
public class TariffData { public int Id { get; set; } public string Code { get; set; } public string Description { get; set; } public string Unit { get; set; } public string Rate { get; set; } public string Rate3 { get; set; } }

If i Limit the number of data by using const string query = "select top 300 a.ID,a.Code,a.Description. The Service works fine. But if I remove the top 300 part I get an error. What is your advice if I want a service to allow our client applications to update their data by using WCF. (11000 records.) I am using visual Studio 2010. C# .Net 4.0

View 3 Replies


Similar Messages:

WCF / ASMX :: Consume Data Service In Client Application

Sep 7, 2010

I am working on WCF Data service which imported stored procedure, as below.

[WebGet]
public List<GetMTSearchResultTest_Result> GettMTSearchResultTest()
{
MediaMarketResearch_PRODEntities ent = new MediaMarketResearch_PRODEntities();
return ent.GetMTSearchResultTest().ToList();
}

when i consuming this in my client application it says error as "The closed type MMRClient.MMRServiceReference.GetMTSearchResultTest_Result does not have a corresponding element settable property." I am getting this error while bind to the grid view as below.

DataServiceContext context = new DataServiceContext(new [URL])); IEnumerable<GetMTSearchResultTest_Result> empResult = context.Execute<GetMTSearchResultTest_Result>(new Uri [URL];

GridView1.DataSource = empResult;
GridView1.DataBind();

Note: I imported this stored proc as complex type.

View 1 Replies

WCF / ASMX :: IIS Memory Increasing For Each Client Request In Asmx Web Service?

Nov 8, 2010

A customer reported that our asmx web service is continually increasing in memory (mem usage as well as private bytes). We are able to reproduce the problem in our lab with Windows 2003 Server SP2 (fully patched) on some of the machines. The customer is using Windows 2008.

We created a Hello World web service targeting the 2.0 framework built under VS2005 SP1 and a test client that continues to call it. The memory increases steadily - approximately 40K per client request. If the test app is paused, the memory remains the same. When it is closed, the memory drops. Explicit calling of GC.Collect does not drop the memory.

We have run the memory profiler on the service and the leak is all native memory. We have uninstalled/re-installed the Framework on one of the machines but no difference. To our knowledge all of the security and IIS settings are not modified. We have compared app pool, default web site and virtual directory properties to machines that have no problem and they are identical.

View 11 Replies

WCF / ASMX :: Create Web Service - How To Web Page Call Sales_Services.asmx

May 5, 2010

if i have the web application with many pages like add order page, edit order page, and delete order page actually they also interact with the Sql Server 2008 and i also create web service page call Sales_Service.asmx. i know just i need to put something like query into Web Method in Sales_Service.asmx but i have a lot of queries, i don't know which query i should put into it and how the web page call the Sales_Services.asmx

View 2 Replies

WCF / ASMX :: JQuery & WCF Data Service - PUT Update - Rejected With 405 Method Not Allowed

Sep 12, 2010

I am writing a sample jQuery/WCF Data Service app to utilize OData, however I am getting a status code 405 - Method not allowed when I attempt to update an entity with a PUT Http method. I have configured my WCF Data Service as follows:

[Code]....

I am attempting to update the jCredentials_PINs table. My jQuery call to update the WCF Data Service is as follows:

[Code]....

I am using Windows 7 / IIS 7.5. GETs against the jCredentials_PINs table work fine. The only web.config configuration information is as follows:

[Code]....

View 1 Replies

WCF / ASMX :: Create An Instance Of Web Service Without Adding Web Service Reference?

Mar 17, 2011

How to create an instance of web service without adding web service reference? How to identify the server address/name where the web service is hosted from C# code?

View 1 Replies

WCF / ASMX :: Create Simple Web Service In VS2010, NOT WCF Service?

Aug 30, 2010

How to create simple web service in VS2010 Professional (trial version). There is no template to do this. I am not trying to create WCF service here.

View 2 Replies

Display Post Data From Vb.net Application To Web Service Asmx That Is Located On Server

Jan 14, 2010

I am trying to post data from vb.net application to web service asmx that is located on server! For posting data from vb.net application I am using this code:

Public Function Post(ByVal url As String, ByVal data As String) As String
Dim vystup As String = Nothing
Try
'Our postvars
Dim buffer As Byte() = Encoding.ASCII.GetBytes(data)
'Initialisation, we use localhost, change if appliable
Dim WebReq As HttpWebRequest = DirectCast(WebRequest.Create(url), HttpWebRequest)
'Our method is post, otherwise the buffer (postvars) would be useless
WebReq.Method = "POST"
'We use form contentType, for the postvars.
WebReq.ContentType = "application/x-www-form-urlencoded"
'The length of the buffer (postvars) is used as contentlength.
WebReq.ContentLength = buffer.Length
'We open a stream for writing the postvars
Dim PostData As Stream = WebReq.GetRequestStream()
'Now we write, and afterwards, we close. Closing is always important!
PostData.Write(buffer, 0, buffer.Length)
PostData.Close()
'Get the response handle, we have no true response yet!
Dim WebResp As HttpWebResponse = DirectCast(WebReq.GetResponse(), HttpWebResponse)
'Let's show some information about the response
Console.WriteLine(WebResp.StatusCode)
Console.WriteLine(WebResp.Server)
'Now, we read the response (the string), and output it.
Dim Answer As Stream = WebResp.GetResponseStream()
Dim _Answer As New StreamReader(Answer)
'Congratulations, you just requested your first POST page, you
'can now start logging into most login forms, with your application
'Or other examples.
vystup = _Answer.ReadToEnd()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
Return vystup.Trim() & vbLf
End Function

View 1 Replies

WCF / ASMX :: Client Web Service And Cookie?

Mar 8, 2011

when client call my web service, i read owner cookie?

For example : When Guest browse www.abc.com, i write a cookie that its name BrowseTime.
www.xyz.com using web service on www.abc.com . Can I get abc.com's BrowseTime cookie when xyz.com call WebService? Or alternative solution like (third part cookie or any)

View 3 Replies

WCF / ASMX :: Add Service As Service Reference To VB6 Winforms Application

Feb 7, 2011

How do I add the WCF service built using VS2010 as a service reference to a Winforms app which is written in VB6?

View 1 Replies

WCF / ASMX :: Receive Client Certificate In Web Service?

Oct 15, 2010

I'm trying to receive a Client Certificate in a Web Service and having some problems.

Client

[Code]....

The certificate seems to be correclty loading and added to the client.

The client connects to the server with HTTPS.

Server:

[Code]....

cert.IsPresent is false and all certificate fields are empty.

IIS is configured to Accept Client Certificates.

Reproduced in two environments:

- Windows 7 x64, IIS 7, VS 2008, .NET 3.5
- XP x86, IIS 5, VS 2008, .NET 3.5

Always in the Web Service the Client Certificate is not proesent. I haven't been able to find any other configuration I should do.

View 1 Replies

WCF / ASMX :: Service Reference On Client Side?

Dec 15, 2010

I am having a strange issue in my C# Console Application:

Name Space: WcfConsoleApp
Main Class: Program.cs
Name Space: WcfConsoleApp.ServiceReference
this namespace contains the WCF service reference

After building the project, the Program.exe avaliable in Debug folder is executing fine as expected.But when i move the exe to Client, where i need to actually run this exe, it works fine up to the line where i am referencing the Service, the line is:

WcfConsoleApp.ServiceReference.ServiceClient service = new WcfConsoleApp.ServiceReference.ServiceClient();

the consoel app crashes on the client machine at this line. (i know this because before this line, i display some mesage on the console)the same .exe and works fine at my development machine.I am sure it has to do some thing with reference path, i think the program is not getting to the path where service reference is avaliable. I have copied the full project folder as it is to the client, but still its is not working.

View 4 Replies

WCF / ASMX :: Error In Consuming Web Service Using WCF Client?

Aug 30, 2010

I have consumed an external webservice in my client application using WCF. And every thing works great in my Dev box(XP with IIS5.1)But when the same application is moved to Prod server(Win Server 2003 with IIS6.0) it fails. Below is the exception caught:

There was no endpoint listening at http://MyExternalWebServiceUrlWithSessionId could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details.And the InnerException is: Unable to connect to the remote server.My Config file has the below settings:

[Code]....

View 1 Replies

WCF / ASMX :: Create A Web Service Which Consists Of CRUD Operations Create?

Jan 20, 2011

i want to create a web service which consists of CRUD operations Create, Retrieve, Update and Delete. creating web methods on insert and update operations.

View 2 Replies

Forms Data Controls :: How To Update A Web Application From The Client

Feb 14, 2011

My web application goes onto several client servers and I wrote a simple VB6 app that when run downloads relevant files and copies them into the directory.If I wanted the web application to perform this update can I assume this is impossible, i.e. FTP the files and copy them accordingly?Also I am now pre-compiling my site each time using the aspnet_compiler and this seems to update every page, do I need to copy each page every time or simply the ones I've changed.

View 1 Replies

WCF / ASMX :: While Consuming The Java Web Service, Getting The Error In Client?

May 20, 2010

I am consuming the java web service in .net client, when i sent a request to that web service, i am getting one exception in response object.It says "Client found response content type of 'text/plain', but expected 'text/xml'", along with this message i am getting the response in that exception.

View 2 Replies

WCF / ASMX :: Unable To Make Connection Between Client And Service

Apr 30, 2010

I receive the following error, when trying to consume Wcf service:

"An existing connection was forcibly closed by the remote host". Consuming the service works fine when the host and the client are on the same machine. When I move the client to Hyper-V virtual machine (I didn't try it on a real computer) - it throws the error. Both firewalls are turned off Do you know what can cause such behaviour? Here are the details:

Both the client (hyper-v) and the service are on Windows server 2008 R2

Service url - http://wcftest/CalculatorService.svc (wcftest is the website and is mapped in the hosts file to localhost)

Service config:

[Code]....

Client config:

[Code]....

Are there any configuration settings which I'm missing?

View 1 Replies

Adding ASMX Web Service Client In Netbeans / Java?

Jan 5, 2011

I was wondering if anything special is required to add a .NET web services to the "Services" tab in NetBeans to allow my java app to consume a .NET web service. I go and add my WSDL (simple method, 1 operation, takes a string), and I continuously get a NullReferenceError as below:

java.lang.NullPointerException
at org.netbeans.modules.websvc.saas.model.wsdl.impl.WsdlModel.getServices(WsdlModel.java:65)
at org.netbeans.modules.websvc.saas.wsdl.websvcmgr.WebServiceManager.addWebService(WebServiceManager.java:142)
at org.netbeans.modules.websvc.saas.wsdl.websvcmgr.WsdlDataManagerImpl$1.run(WsdlDataManagerImpl.java:79)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1418)
[catch] at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1957)

Is this something common? I'm using Netbeans 6.9.1 and yes, the webservice is a stub that takes a string and displays a static message right now.

View 1 Replies

WCF / ASMX ::access The Client's Credentials Inside A WCF Service?

Jan 26, 2011

I have a silverlight application that uses WCF service and i need to provide windows authentication using wcf.In order to achieve this i am trying to retrieve the client's credentials (windows credentials)inside wcf.

View 1 Replies

WCF / ASMX :: Store A Pdf File On Client Machine Using A Web Service?

Feb 23, 2011

I need to store a pdf file on client machine using a web service.

I am unable to find IP address of client machine in web service so that I can insert pdf file in C-drive of client machine.

I am using asp.net 3.5 using c#.

View 2 Replies

WCF / ASMX ::pass Xml Document To A Method In WCF Service By Client?

Aug 2, 2010

I would like to pass xml document to a method in WCF service by client that server will get xmldocument,parse it and send back the xml response.What are best practice for thi?The xml document is conform to XSD so i would like to create managed type that represent the schema and then expose thatIf anybody has done it before or know any example please point it out so i can see it.

View 1 Replies

WCF / ASMX :: Consuming Web Service In A Client Code (JavaScript)?

Mar 29, 2011

Most WCF web service I have developed were consumed in a server side code (by adding a service reference in visual studio or creating a proxy class using svcutil.exe. I have never consumed a web service in a client code. So I apologize if I am using wrong terminology or my question does not make sense.We have a browser add-on or plugin that connect to a device on client computer (think of it as active-x control for internet explorer) inside a asp.net web page.This browser plugin/add-on then will be sending measurement data to the web server. After some research it appears to me that I can do eithera) Develop an AJAX enabled WCF web service and use script manager and javascript to consume it inside the web page that interact with browser pluginb) Develop a WCF web servcice (not sure about AJAX enable) that serialize request and response to JSON, and use JQuery inside asp.net page to consume it.QuestionWhat's difference between approach a) and b)? Which is better in particular scenario I have described.

View 4 Replies

WCF / ASMX :: Get Web Service Client Info From Incoming Call?

Apr 8, 2010

I have a (relatively) simple web service host. This ws exposes two methods: verify and processRequest.

Is there a way for the host to get information about where the request is coming from?

I am looking for things like IP Address, time/date sent, payload size (and maybe entire message size), etc...

I can not use custom SOAP headers, so I need to rely on whatever is in the default SOAP header.

I am writing my code in C#.

View 1 Replies

WCF / ASMX :: Client DataContract Has Empty/null Values From Service?

Mar 26, 2010

I have a simple WCF service that returns the time from the server. I've confirmed that data is being sent by checking with Fiddler. Here's the result object xml that my service sends according to fiddler.

[Code]....

Literally the only difference is the namespaces within the application. But still the values being returned are null, empty or a .NET default.

View 1 Replies

WCF / ASMX :: Invoke Web Service From Client At Body's Onunload Event

Feb 21, 2011

as part of a log feature that my client asked for, I'm tring to monitor whenever the browser is closed by the user.

I have created a new web service, registered it the ScriptManager (like in this exmple [URL]

The web method is this:

[Code]....

When I put a break point it is reached, but the executenonquery won't fired.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved