ADO, database Direct-Connect

Database connections: Direct-connect and disconnected

using System.Data using System.sqlclient

Connection creating a connection to the database: 1, server 2, authentication 3, specifying the database

"." On behalf of native or (local), database is the name of the databases, if using Windows authentication with integrated Security = true;

New"server =.;D atabase = Stu;uid = sa; PWD = 123";
Conn. Open ();

Command

// Constructing Command Objects New  "select * FROM student"= con;

Datareade

// declaring a result set SqlDataReader dr = com. ExecuteReader (); // Traverse Dr Data if (Dr. HasRows) {      Whlie (Dr. Read) {  ListBox1.Item.Add (dr[1]. Tostring ());}}
Con. Close ();

All the mistakes of the whole hand

ADO, database Direct-Connect