how we compare textbox value with database value in vb.net

Question

3.00/5 (1 vote)

See more:

VB

i m making electronic paper system
how can i compare textbox fields with SQL database values on my login button?

Posted 5-Jan-13 0:28am

hunain261

Add a Solution

Comments

Casey Sheridan 5-Jan-13 8:39am

Do you have any knowledge of SQL or are you looking for complete code?

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2013-01-06T02:01:00

How can i compare textbox fields with SQL database values on my login button?
Steps:
1. On login button press, raise the click event. Write your comparison code here in this click handler.
2. Now, using ADO.NET, connect to database. Form a query for comparison of the value in DB
3. Run the query and get back the result
4. Take action based on the result returned.

Few references that would help:
MSDN: Accessing Data with ADO.NET[^]
Using ADO.NET for beginners[^]
Simple ADO.NET Database Read, Insert, Update and Delete using C#.[^]

rb_contra · Answer 2 · 2013-01-06T02:08:00

VB

con.con_open()

        Dim cmdlogin As New SqlCommand(("SELECT * FROM users WHERE user_name='" & _
                                            txtuname.Text & "' and password='" & _
                                            txtpassword.Text & "'"), con.con)
        Dim dalogin As New SqlDataAdapter
        Dim dslogin As New Data.DataSet
        dalogin.SelectCommand = cmdlogin
        cmdlogin.ExecuteNonQuery()
        dslogin.Clear()
        dalogin.Fill(dslogin, "users")


        If dslogin.Tables(0).Rows.Count > 0 Then

        Else
            
        End If

'--------------------or

        if txtusername.text=dslogin.Tables(0).Rows(0).Item(0).ToString then

        else

        end if

'--------------------

        con.con_close(

Espen Harlinn · Answer 3 · 2013-01-06T03:31:00

Solution 4

SQL database values on my login button
Please don't do this yourself, use ASP.NET Authentication[^].

Security is a thorny issue which requires an in depth understanding of a wide range of technologies. ASP.Net provides authentication and authorization out of the box, so there is no need to implement this yourself.

Best regards
Espen Harlinn

Posted 6-Jan-13 3:31am

Espen Harlinn

Comments

Wendelius 6-Jan-13 10:58am

Good point!

Espen Harlinn 6-Jan-13 10:59am

Thank you, Mika :-D

how we compare textbox value with database value in vb.net

3 solutions

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

how we compare textbox value with database value in vb.net

3 solutions

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us