Please help me in Web Services !!

kishore_peddi

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

Bill25

: 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?

kishore_peddi

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