Login web servisi
Login web servisi
Basit bir login web servisi
codeDivStart()
Imports System.Web.Services
Imports System.Data.SqlClient
<System.Web.Services.WebService(Namespace:="http://localhost/EOS/slogin")> _
Public Class slogin
Inherits System.Web.Services.WebService
#Region " Web Services Designer Generated Code "
Public Sub New()
MyBase.New()
'This call is required by the Web Services Designer.
InitializeComponent()
'Add your own initialization code after the InitializeComponent() call
End Sub
'Required by the Web Services Designer
Private components As System.ComponentModel.IContainer
'NOTE: The following procedure is required by the Web Services Designer
'It can be modified using the Web Services Designer.
'Do not modify it using the code editor.
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
components = New System.ComponentModel.Container
End Sub
Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
'CODEGEN: This procedure is required by the Web Services Designer
'Do not modify it using the code editor.
If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If
MyBase.Dispose(disposing)
End Sub
#End Region
<WebMethod()> _
Public Function sql(ByVal a As String, ByVal b As String) As String
Dim DBConn As SqlConnection
Dim DBCommand As SqlDataAdapter
Dim DSPageData As New DataSet
DBConn = New SqlConnection(server=(local);database=deneme;trusted_connection=true)
DBCommand = New SqlDataAdapter _
("Select * From tablom Where " _
& "a = '" & a & "' " _
& "And b = '" & b & "'" _
, DBConn)
DBCommand.Fill(DSPageData, _
"tablom")
If DSPageData.Tables("tablom").Rows.Count = 0 Then
Return ("hata var")
Else
Return ("giris tamam")
End If
End Function
End Class