How to access DataSet from a remote machine

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rizwan6feb
    New Member
    • Jul 2007
    • 108

    How to access DataSet from a remote machine

    There are two versions of my application. First runs on a local server and the second version runs on a client machine.

    The application on the local server performs that following tasks

    1. Pulls data from an online Mysql database and stores it in a DataSet
    2. Makes changes in the DataSet and updates it back in the online database

    I need to access the data (i.e the DataSet) on the client machine, so that the client can also Add, Edit and Delete records. Is there any way i can achieve this?
  • Frinavale
    Recognized Expert Expert
    • Oct 2006
    • 9749

    #2
    When the client machine needs to perform the update, have it call a server function which accepts the DataSet as parameter....I' m assuming your sever application is a Web Service or WCF application.

    -Frinny

    Comment

    • rizwan6feb
      New Member
      • Jul 2007
      • 108

      #3
      Originally posted by Frinavale
      When the client machine needs to perform the update, have it call a server function which accepts the DataSet as parameter....I' m assuming your sever application is a Web Service or WCF application.

      -Frinny
      From where the client machine will get that DataSet ?

      Comment

      • Curtis Rutland
        Recognized Expert Specialist
        • Apr 2008
        • 3264

        #4
        Originally posted by rizwan6feb
        From where the client machine will get that DataSet ?
        You would have to make the application into a WCF service or webservice, or implement some kind of client-server protocol to pass objects between different programs.

        Comment

        • Frinavale
          Recognized Expert Expert
          • Oct 2006
          • 9749

          #5
          Originally posted by rizwan6feb
          From where the client machine will get that DataSet ?
          You will get the DataSet from wherever you stored it.
          Have you implemented a web service?

          Please provide more details about your project so that we can help you better.

          -Frinny

          Comment

          Working...