Visual Basic

SELECT COUNT(Username) FROM Users WHERE Username=?Username And Password=?Password

Public Function AttemptLogin(ByVal Username As String, ByVal Password As String) As Boolean
    Dim queryString As String = "SELECT COUNT(Username) FROM User WHERE Username=?Username AND Password=?Password"
    Dim result As Integer = 0
    Using connection As New OleDbConnection(connectionString)
        Dim command As New OleDbCommand(queryString, connection)
        command.Parameters.Add(New OleDbParameters("?Username", OleDbType.VarChar, 15)).Value = "someusername"
        command.Parameters.Add(New OleDbParameters("?Password", OleDbType.VarChar, 15)).Value = "somepassword"
 
        connection.Open()
        result = command.ExecuteScalar()
        connection.Close()
 
        Return (result=1)
    End Using
End Function

Imports System.Text.RegularExpressions
.
.
.
' Define a RegEx expression that matches strings
' of 1 or more whitespace characters.
Dim re As New Regex("\s+")
Dim i As Integer = 1
While Not myreader.EndOfStream
    line = myreader.ReadLine()
    line = i & re.Replace(line, vbCrLf)
    mywriter.WriteLine(line)
    i += 1
End While

Dim emailAddr As String = ComboBox.SelectedValue

Dim emailAddr As String = ComboBox.SelectedValue @ "@someplace.com"

<br />
Dim Email As New System.Net.Mail.MailMessage( _<br />
    "email@email.com", ddlLocation.SelectedValue)<br />

Marwan Ekwanin wrote:

I need your help please to tell me how I can send and receive numerical data (not string data) from client to server and vice versa.