SqlConnection conn = new SqlConnection(strSqlConn);
conn.Open();
SqlCommand comm = new SqlCommand("坦梁Select * from tablename");
SqlDataAdapter adpt = new SqlDataAdapter(comm);
DataTable dt = new DataTable();//select取回的岩厅值让枣运
adpt.Fill(dt);
conn.Close();