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