Seeking to use the simplest VB.NET language to connect SQL in ASP.NET

soulstong

I don't want to use in Default.aspx
       
<% @ Import Namespace = "System.Data"%>
<% @ Import Namespace = "System.Data.Sqlclient"%>
       
This method is connected to SQL. I want to write in VB.NET language in Default.aspx.vb. Please give me the simplest connection method, because I am a novice, I am afraid that it is too deep

Please masters give detailed code, if there is a place to define, please give a definition.

tommyair

First, reference the code Imports System.Data.SqlClient at the top of the Default.aspx.vb page.
Then give you an example to understand.
Dim con As New SqlConnection ("server = .; database = jie; uid = sa")
// server =. It means the machine is connected, the database name is added with the database name you want to connect, the user name and password are your own.
        Dim cmd As New SqlCommand ("select Uid from user table where user name = '"&TextBox1.Text&"' and user password = '"&TextBox2.Text&"'", con)
        Dim dr As SqlDataReader
        con.Open ()
        dr = cmd.ExecuteReader
        If dr.Read Then
            Response.Redirect ("WebForm1.aspx")
        Else
            Response.Write ("<script> alert ('The username or password is wrong') </ script>")

        End If
        dr.Close ()
        con.Close ()

bjpapaya

dim con as sqlconnection = New SqlConnection (System.Configuration.ConfigurationManager.ConnectionStrings ("sweaterConnectionString"). ToString)

tuqiang

First add this sentence in the config file:
<appSettings>
<add key = "StrCon" value = "server = IP or service product name; uid = sa; pwd =; database = database name" />
</ appSettings>

Then when you want to connect to the database in the .vb file, add this sentence:
dim conn as new SqlConnection
conn = System.Configuration.ConfigurationSettings.AppSettings (StrCon)