//声明数据库连接字符串变量
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);
}
}
}