Author: pinoyz | Posted on: 9/2/2009 3:10:08 AM | Views : 227

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 ...