Because of the graduation project, I ask all the experts to connect to SQL, younger brother, thank you!

soulstong

I want to ask, 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 use the VB.NET language in Default.aspx.vb. How should I write it? Thank you!

shenmue024

sure.
Change it to vb.

SqlConnection conn = null;
SqlDataAdapter dapt = null;
DataSet ds = new DataSet ();
string strConnectionString = "Data Source = .; initial catalog = database; uid = sa; pwd = xxx";
string strSQL = "SELECT field from table"
try
{
conn = new SqlConnection (strConnectionString);
conn.Open ();
dapt = new SqlDataAdapter (strSQL, conn);
dapt.Fill (ds, "table1");
DataTable dt = ds.Tabls [0];
if (dt.Rows.Count> 0)
{
this.Text1.Text = dt.Rows [0] ["field"]. ToString ();
}
Ranch
}
catch (System.Exception e)
{
this.Text1.Text = "Error" + e.Message;
}
finally
{
if (conn! = null)
conn.Dispose ();
if (dapt! = null)
dapt.Dispose ();
}

evening

Create connection first

everever30

Import System.Data
Import System.Data.Sqlclient

sumu007

private static void OpenSqlConnection ()
{
    string connectionString = GetConnectionString ();
    using (SqlConnection connection = new SqlConnection (connectionString))
    {
        connection.Open ();
        Console.WriteLine ("ServerVersion: {0}", connection.ServerVersion);
        Console.WriteLine ("State: {0}", connection.State);
    }
}

static private string GetConnectionString ()
{
    return "Data Source = (local); Initial Catalog = AdventureWorks;"
        + "Integrated Security = SSPI;";
}

soulstong

May I ask, can it be simpler? I'm new, I don't understand
The first floor is ok, but it is written in many places. Can you give the number you want to define?

59433945

Import System.Data
Import System.Data.Sqlclient
Reference these two at the beginning

ec10dlong

Dim student_id As String = Request.Cookies ("userInf"). Values ​​("userID")


        Dim mySqlConnection As String
        mySqlConnection = "Data Source = localhost; initial catalog = user; user id = lgw; password = lgw; connect timeout = 30"
        Dim connuser As New Data.SqlClient.SqlConnection (mySqlConnection)
        conn.Open ()

        Dim strSql As String = "select * from users where id ="&student_id