Author: supermedo84@gmail.com | Posted on: 9/16/2008 6:57:06 AM | Views : 769

hi,
i create single webservice layer connect to database the database is sql server 2005 okkk
but i have the following error and i can't get it

error
----
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Incorrect syntax near 'LogUSer'...

My code


Dim sqlCon As SqlConnection
Dim sqlCom As SqlCommand
Dim sqlda As SqlDataAdapter
Dim DS As DataSet

Public Function startConnection() As Integer
Dim sConnection As String = ConfigurationManager.ConnectionStrings("MyCon").ConnectionString
sqlCon = New SqlConnection(sConnection)
sqlCom = New SqlCommand("", sqlCon)
Return 1
End Function

Public Function Excute_Quary_StrdPro_P(ByVal strdProName As String, ByVal ParamArray _par As IDbDataParameter()) As DataSet
startConnection()
DS = New DataSet()
sqlCom.CommandText = Comman ...

Go to the complete details ...