asp.net连接数据库
1. 生成一个连接对象
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["SQLConnString"].ToString());
2. 生成一个命令对象
SqlCommand com = new SqlCommand("select * from Users",con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
3. 读取值
while (dr.read())
{
Response.Write(dr["username"]);
}