Programalama > ASP.NET

Etiketler: login, web, servisi

Ort. 0
Puan ver:
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


Yorumlar                 Yorum Yaz
Bu hazır kod'a ilk yorumu siz yapın!
KATEGORİLER
ASP - 240
ASP.NET - 24
C# - 75
C++ - 174
CGI - 8
DELPHI - 247
FLASH - 49
HTML - 536
PASCAL - 246
PERL - 11
PHP - 160
WML - 9
XML - 2
Copyright © 2002 - 2019 Hazır Kod - Tüm Hakları Saklıdır.
Siteden yararlanırken gizlilik ilkelerini okumanızı tavsiye ederiz.
hazirkod.com bir İSOBİL projesidir.