
June 23rd, 2003, 06:40 PM
|
|
Registered User
|
|
Join Date: May 2003
Posts: 8
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
End Of The Statement Error
Hi<br> I am trying to compile a sample web service and I am getting these two error. <br>a)End of statement expected(line56), I checked the line I see " and the end<br>b)Name 'sConn' is not declared(line70), it's declared ????<br>================================================== =<br>Public Function GetAuthors(ByVal sValue As String) As DataSet<br><br><br><br> Dim sSQL As String = "SELECT au_lname, au_fname, phone,address,city, state, zip FROM Authors Where state='" + sValue + "'"<br><br> <br> Dim sConnAs String</span>="SERVER=localhost; UID=sa; PWD=; DATABASE=pubs;"<br><br> <br> Dim ds As New DataSet<br><br> <br> Dim da As New SqlClient.SqlDataAdapter(sSQL, sConn)<br><br><br><br> <br> da.Fill(ds, "AuthorsList")<br><br><br><br> <br> Return ds<br><br>End Function <br><br><br><br><br>End Class
|