Hi,
I created a small Webservices and returns as Datatable, Am I doing right?
<WebMethod()> _
Public Function ItemLookUp(ByVal Data As String) As String
Dim cn As New SqlConnection(ConfigurationManager.ConnectionStrings("temp_dbaccpac").ConnectionString)
Dim cmd As New SqlCommand("Select [DESC] From ICITEM Where ItemNo = @Item", cn)
cmd.Parameters.Add(New SqlParameter("@Item", SqlDbType.VarChar, 50)).Value = Data
cn.Open()
Dim rd As SqlDataReader = cmd.ExecuteReader
While rd.Read
If rd.HasRows Then
...
Go to the complete details ...