Please help me in Web Services !!

Hi,

Good day. I want to create a dataset in web services and return it to the user. The user will update the dataset and send it to the sever so that again i will update the database. Please help me by giving code for the problem...


Advance ThanX for your time & patience.

Bye...
Kishore

Comments

  • : Good day. I want to create a dataset in web services and return it to the user. The user will update the dataset and send it to the sever so that again i will update the database. Please help me by giving code for the problem...

    ------------------------------------------------------------------------

    1: Where will the Connection be ? To what kind of database ?
    2: How will you display the data ? Datagrid, textboxes?

  • Hi,

    I am giving the entire code for the Web Service. Assume that both client and server applications are running on local system.

    CODE:-
    ====

    Imports System.Data.OleDb
    Imports System.Web.Services

    Public Class Service1
    Inherits System.Web.Services.WebService

    Dim Cn As OleDbConnection
    Dim Da As OleDbDataAdapter
    Dim Ds As DataSet


    _
    Public Function GetData() As DataSet

    Cn = New OleDbConnection("Provider=MSDAORA.1;Password=tiger;_
    User ID=scott;Data Source=tit")
    Cn.Open()

    Da = New OleDbDataAdapter("Select * from T", Cn)
    Ds = New DataSet()
    Da.Fill(Ds, "T")

    Return Ds
    End Function

    _
    Public Function UpdateData(ByVal obj As DataSet)
    Da.Update(Ds)
    End Function
    End Class

    Think that my client is VB.NET and i am displaying the result in "DataGrid" control. And the records will be shown to the user in DataGrid and user can modify the data so that i want to send the dataset back to the server and i want to update it again. So please sugest that the way to do that one.

    Many ThanX for your sincere reply...

    Bye..
    Kishore

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories