connect to SQL using asp.net

Question

anyone can help me to connect to SQL server through vb.net using asp.net webform.. I have the database name Users and i want to use the database for the login page.. please help me..

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim ConnectionString As String 
    ConnectionString = ConfigurationSettings.AppSettings("ConnectionString")
    Dim con As New SqlConnection(ConnectionString) 
    Dim cmd As New SqlCommand("Select UserId, Pwd from Users", con) 
    con.Open()
    Dim myreader As SqlDataReader
    myreader = cmd.ExecuteReader() 
    While myreader.Read()
        If TxtUserId.Text = myreader("UserId").ToString().Trim() 
           AndAlso TxtPwd.Text = myreader("Pwd").ToString().Trim() Then
            Session("UserId") = TxtUserId.Text 
            Response.Redirect("UserMyProfile.aspx") 
        Else 
            lblMsg.Visible = True 
            lblMsg.Text = "Inavalid UserId/Password" 
        End If
    End While
    con.Close() 
End Sub

Google can help you... lots of examples startvbdotnet.com/ado/sqlserver.aspx — Chris Diver
– Chris Diver, Commented Mar 28, 2011 at 10:32
i have tried the code already.. but, when i debug, there are some errors.. i'm a beginner in asp.net.. — tan keng
– tan keng, Commented Mar 28, 2011 at 10:35
@tan keng: If you're getting specific errors, you can ask a question here about those errors. We're happy to help. — David
– David, Commented Mar 28, 2011 at 10:35
It's better to post what you have tried and what errors you are encountering, from that point you will get the help you need. — Chris Diver
– Chris Diver, Commented Mar 28, 2011 at 10:36
i tried that coding before.. but there are still some errors — tan keng
– tan keng, Commented Mar 28, 2011 at 10:41

David · Accepted Answer · 2011-03-28 11:52:57Z

1

There's no shortage of tutorials on the web for this, but a good starting point is here.

EDIT: Based on your comments above, it sounds like you're not importing the Namespace you need for the ADO.NET data objects. Try adding this to the class file:

Imports System.Data.SqlClient

edited Mar 28, 2011 at 11:52

answered Mar 28, 2011 at 10:34

David

221k42 gold badges245 silver badges337 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

tan keng Over a year ago

david, do u have some sample of asp.net web? i want to study more about asp.net since i'm newbie for asp.net

David Over a year ago

@tan keng: There's really no shortage of examples and tutorials online. Google can give you a lot more than I can. (Additionally, I'm not a very good teacher. My example applications won't be... beginner level.) Also, "I want to learn ASP.NET" is way too broad a topic for Stack Overflow. Specific questions, such as the code you posted and the errors you saw, are great here. But this isn't really a tutorial site.

Collectives™ on Stack Overflow

connect to SQL using asp.net

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related