SqlConnection类连接数据库，附加简单查询

private void Connect()
{
   SqlConnection conn;
   SqlCommand cmd;
   SqlDataReader dr = null;

   //服务器名称 \ 数据库实例名 (本机数据库可以用 "." 或"127.0.0.1" 代替)
   string connectionString1 = "Data Source=.;";
   //数据库名称
   connectionString1 += "Initial Catalog = TestTable;";
   connectionString1 += "Persist Security Info = True;";
   //用户名/密码
   connectionString1 += "User ID = sa;Password = Aa123456;";
   connectionString1 += "Max Pool Size = 512;";

   conn = new SqlConnection(connectionString1);
   conn.Open();

   string sql = "select * from Student where id > 1 ";
   SqlDataAdapter sda = new SqlDataAdapter(sql, conn);

   //创建DataSet类的对象
   DataSet ds = new DataSet();

   //使用SQLDataAdapter对象sda将查询结果填充到Dataset对象ds中
   sda.Fill(ds);

   //设置ListBox控件的数据源（DataSource）属性
   var table = ds.Tables[0];
   dataGridView1.DataSource = table.Copy();
}