//声明数据库连接字符串变量

string strconn = ConfigurationManager.ConnectionStrings["dbstrConn"].ConnectionString;

using (SqlConnection conn = new SqlConnection(strconn)) { //打开连接 conn.Open(); //创建命令 using (SqlCommand cmd = conn.CreateCommand()) { //sql语句 cmd.CommandText = "select * from T_user"; SqlDataAdapter adpter = new SqlDataAdapter(cmd); DataSet ds= new DataSet(); //填充数据集 adpter.Fill(ds); //创建数据表 DataTable table= ds.Tables[0]; DataRowCollection rows = table.Rows; //遍历数据表的每行 for (int i = 0; i < rows.Count; i++) { DataRow row = rows[i]; //获取列内容 string name=(string)row["name"]; MessageBox.Show(name); } } }