From a database to a WCF Service to a form

I was wondering how I can get a simple fill statement to show up in a wcf service library function and thgen how do I connect it to a datagrid in a forms document help would be much appreciated since i need to do the same thing only with a WHERE clause for the last nmame that the main form provides.

4/26/2009 8:46:15 AM 7071 articles. 0 followers. Follow

6 Replies

Similar Articles

[PageSpeed] 35

 call in operation contract like this


public DataSet getdata()


write some code

 return ds;



u add service refernce

in code behind u need to write like this

LocalHost proxy=new  LocalHost();

DataSet data= proxy.getdata();



4/30/2009 7:37:44 AM

Could you put that in VB code please?

5/1/2009 6:26:56 AM

 <OperationContract> _
Public Function getdata() As DataSet

 Return ds

End Function

Private proxy As New LocalHost()

Private data As DataSet= proxy.getdata()



5/3/2009 5:27:18 AM

 i'm not sure how to translate my code to your code this what i Have so far


     <OperationContract()> _
    Function CustomerListAll() As CustomersDataSet1.CustomersDataTable


is in IService1.vb


     Public Function CustomerListAll() As CustomersDataSet1.CustomersDataTable Implements IService1.CustomerListAll
        Dim r1 As New CustomersDataSet1TableAdapters.CustomersTableAdapter

        Return r1.GetData
    End Function


Is in the Service1.vb

    Private Sub btnAll_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAll.Click
        Dim r1 As New CustomersServiceReference.Service1Client
        Dim wcfs As New WcfServiceLibrary1.Customer
        Dim wcfx As New WcfServiceLibrary1.CustomersDataSet1

    End Sub


Is in the button that I am using


Any help in telling me where my data is wrong is appreciated


5/3/2009 8:09:46 PM

 It's definitely a bad idea to send a DataSet type with OperationContract. Just think about the fact that with OperationContract you send data over the wire, so you should keep your data as simple as possible. A DataSet is something enormous to be sent :).

5/4/2009 3:39:35 PM

 I would love to do this another way however thge assignment specifically states that all the forms application will do is recieve that data all data manipulation is done in thge wcf the dataset and database is only suppose to be in the wcfserviicelibrary.  So, i still need to know how to manipulate my dataset in thge ;ibrary to be recieved in the form

5/4/2009 4:33:22 PM

Similar Artilces:

xml web service --uploading the file to the xml web service
how can we upload the file in the xml web service 1.i mean what will be the return value in the proxy class 2.and how am i going to send the file to the xml web service----regards Bipul Kumar Here are some links to articles that helped us get this done: Hope this helps....

How to call a .net web service from another .net web service?
Hi all,I have developed two asp .net web services using visual studio .net 2003.I wish to call one web service from another web service.I tried adding a web reference of the web service in another web service and was able to do so.but i m not able to access the web methods provided by the web servicecould you please suggest a way to go about itExpecting quick replyThanxCharmy try to make sure that you reference it in the web reference and call it properly this is sample  [WebMethod()] public double CalcDistance(int x1, int y1, int x2, int y2) { Calculator.Service1 calc = new...

Web service in .NET from Java Web Service
Hi there,I'm pretty new to .net (although i have years of experience with the old vb 6, access 2k, as well as java)... and need some with perhaps either some syntax or something.Here is the wsdl.<wsdl:definitions targetNamespace="">−<wsdl:types>−<schema targetNamespace="GetBookInfoByISBN">−<complexType name="BookInfoType">−<sequence><element maxOccurs="1" minOccurs="0" name="Title" nillable="true" type="xsd:string"/><element maxOccurs=&quo...

.NET web services Vs Java Web Services
Hello, does anyone know of a book or good source of information that compares .NET and Java Web Services? (I would like soemthing neutral if possible). I am thinking of approaching this subject for my dissertation? Many Thanks Rob Hi Rob, Last year I had to give a powepoint presentation on Web Services. I noticed some good books at barnes and noble that discussed the subject. These books were specific to Java and discussed Web Services in a very clear fashion. They gave some elementary examples that were easy to understand. I have not yet had the pleasure of creatin .NET Web Servi...

XML Web service , Web form
hi i hope if u could help me in what i am making so i have a web form that does the collection of the information from the user when he hits the button this data must be sent to the xml web service but this service must deliver this data in xml then i read the information and insert it to the sql serevr Database could you help me becouse iam soo confused about where to start and what is the stuff to search in it iam new in the xml stuff help me pleaseeeeee“To be incredible you must produce great work”Visit My Blog My first question is why are yo...

Manipulating Microsoft DNS service from web service or web form.
Hiya All,   I need to be able to update an "A record" on Microsoft DNS Service for a particular domain from a web form or web service - and have no idea where to begin. I can run the form/service on the same box running DNS service... I am looking to make a IP address updater that will update my "home" ip address if it changes (similar to what DYNDNS offers, except I have my own name servers, so that wont work for me lol). Any kick in the right direction is greatly appreciated!   Dave...

Calling a WCF service from a Web Service
I'm trying to call a WCF service from within a Web Service. But after I add a reference to WCF service in Web Service project,  it does not work. I get error following "The type or namespace name 'MyWCFService' could not be found (are you missing a using directive or an assembly reference?) " Adding same WCF service in a web site project works just fine.  Please advise.  thanks...

.Net Web Form & Web Service Deployment
Hi all I have written some test web services and some web form applications and deployed them to my IIS. That's fine but I now want to deploy them to my real IIS server. I have created an msi for each but the problem is I seem to only be able to deploy to the default web site. Our default web site is turned off and instead we use several other sites. Does anybody happen to if Powerbuilder 11 supports non default web sites? If not do I need to hack the msi and if so can anybody suggest a suitable tool. I have Orca but it's not very friendly. Unless of course I knew exactly w...

Form postback to WCF Web Service (New to WCF)
I had a simple asp page which received HTTP post variables and wrote them to a page using VB Script. I wanted to update this to a WCF Project but I am brand new to WCF. My first WCF project was to create a Web Service and create a simple method for multiplying two numbers together. That part was fairly easy. I was able to publish the service to an IIS server, add WebRefence to a new Web Form Project and execute the method returning the result to a variable on the page. What I want to do now is create a simple form pretty much identical to:

Best Practice for .Net Web Service access to a Web Service on a Test and Production Servers
Hello All, What is the best way to control a .Net web service to be able to access a remote server for testing and then point to another remote server to access the web service in production? Do I need to generate and maintain 2 different proxy objects? TIA, Bob Bob // first create the proxy if not isvalid( i_service) then i_service = create fundtraderproxy_TradeServicesClient_BasicHttpBinding_ITradeServices end if ///You'll see code something like this in the constructor of your proxy //dynamically set the endpoint url with the user supplied value - //r...

create valid xml to send to web service based on the schema provided by web service
Problem: I have a web page which is being populated from a dataset containing multiple tables.  I now need to call a web service and send the majority of this data to be incorporate into a mainframe system.  I have been supplied with the schema that the web service will be using to validate the data.  I am new to web services and I am not sure how to take my existing dataset and transform it into an xml document that matches the schema I was provided with. There is a main schema with an element which is a custom complex type.  This custom type consists of an element whi...

New to web services, why does PB10 web service proxy wizard say there are no services?
here... oops typo... still doesn't show any services though... "Chance" <> wrote in message news:43b44cb3$1@forums-1-dub... > here... > > > Upgraded to 10.2x and now seems to be least it created the proxy. "Chance" <

Has anyone successfully used a Delphi web service client against an ENCRYPTED WCF web service server?
Has anyone successfully used a Delphi web service client against an ENCRYPTED WCF web service server? Which is to say, of course, that the URL would be starting with https. Anyone? ...

what are web services and what are the advantages of web services?
 Hello  i am new to this .net stuff and i was ask on the job interview what a web services is?and if i did not know given that i had a project ( as a project manager,  or a web developer)   what  is it? how do i start a >NET project on it? what are the main advantages is?  HOW DO I START THIS IN THE INTERVIEW>  and what basic books do i buy?   Hi There, There plenty of source on the net about webservice Definiton:

Calling a Web Service from a Web Service
Hello,I was looking for some feedback on calling a web service from within a web service. I've heard that it's not good practice (or not possible). I have a scenario where I think it might make some sense.Within our infrastructure, we've created a web service that handles incoming updates on the statuses of all processes. This has proven to be a good thing since it allows applications to communicate across server to make status updates. It's also used by third party developers and applications to communicate with our infrastructure.Along these lines ... we are planning to create a new compon...

Web resources about - From a database to a WCF Service to a form -

Database - Wikipedia, the free encyclopedia
A database is an organized collection of data . The data are typically organized to model aspects of reality in a way that supports processes ...

Database - Wikipedia, the free encyclopedia
... requiring information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database ...

Social Side of Code, Database CI and REST API Testing in Methods & Tools Winter 2015 issue
... for software developers, testers and project managers – has published its Winter 2015 issue that discusses the social side of code, database ...

A look ahead at the state of the database in 2016
... identity management, anti-phishing education, and so forth. Ultimately, hackers want access to the contents of an enterprise's database. Security ...

Huge database of 191 million U.S. voters found on the open Internet
... such bulk information online, a recent discovery seems to indicate. According to VentureBeat , a security researcher found the exposed database ...

Top US School District Switches to Rimini Street for Oracle Database and Oracle E-Business Suite Support ...
Douglas County School District using savings from Rimini Street independent support to develop district-wide data visualization capabilities ...

IDG Contributor Network: Shrinking an already ginormous SharePoint database transaction log
Last month, I wrote about how to avoid having ginormous transaction logs within SharePoint databases. But what if it’s too late, and your files ...

Massive Voter Database Left Open For Public Consumption
Gosh, we could have avoided all the angst about the Clinton/Sanders voter database breach if only we'd known about this major database , accessible ...

18 million targeted voter records exposed by database error
A second database containing voter records has been exposed due to a configuration error. While the first held records that some dismissed inconsequential ...

Former Ohio cop uses cop database to stalk victim
... stalked her like an average person would, but stalked her in the way that only a police officer could: he stalked her utilizing a police database ...

Resources last updated: 1/23/2016 3:25:45 AM