I need to do a simple thing: 3-tier app using XML web extensions.
Web Server should get data from database and send it to a client. I never did it before and I am stuck. On-line help doesn't make it easier. Can someone walk me through?
I created a Web Service with methods such as
<WebMethod> Public Function GetData(ByVal sSQL As String) As DataSet
Dim oCmd As SqlCommand = New SqlCommand(sSQL, cn)
Dim da As SqlDataAdapter = New SqlDataAdapter(oCmd)
Dim ds As New DataSet()
Try
da.Fill(ds)
Return ds
Catch e As SqlException
MsgBox(e.Message)
cn.Close()
End Try
End Function
What should I do next? How do I connect client to this service?
How do I test it?
Please, help
Web Server should get data from database and send it to a client. I never did it before and I am stuck. On-line help doesn't make it easier. Can someone walk me through?
I created a Web Service with methods such as
<WebMethod> Public Function GetData(ByVal sSQL As String) As DataSet
Dim oCmd As SqlCommand = New SqlCommand(sSQL, cn)
Dim da As SqlDataAdapter = New SqlDataAdapter(oCmd)
Dim ds As New DataSet()
Try
da.Fill(ds)
Return ds
Catch e As SqlException
MsgBox(e.Message)
cn.Close()
End Try
End Function
What should I do next? How do I connect client to this service?
How do I test it?
Please, help