[tamerr89]

Basit bir login web servisi

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