asp网页制作中,如何读取数据库内容?

比如,我用VS2005新建一个ASP网站,在default.aspx中,想要得到数据库里的一个名字,应该怎么实现?采用ADO方法连接数据库

现在

服务器名: localhost

数据库名: data

表名: stu

列名: sno , password

用户: sa

密码: 123456

想要查找 sno = 8888 这一行的 password 的值

string connectionString="server=localhost;database=data;uid=sa;pwd=123456";

string SQLString="select password from stu where sno = '8888' ";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
Sqlcommand cmd= new Sqlcommand(SQLString, connection);

strpwd=cmd.ExecuteScalar().ToString();

}

在配置文件中加一个节点

<appSettings>

<add key="connStrings" value="Data Source=localhost;DataBase=data;User ID=sa;Pwd=123456;">

</appSettings>

string connectionString="server=localhost;database=data;uid=sa;pwd=123456";

string SQLString="select * from stu where sno = '8888' "; using (SqlConnection connection = new SqlConnection(connectionString)) { DataSet ds = new DataSet(); try { connection.Open(); SqlDataAdapter command = new SqlDataAdapter(SQLString, connection); command.Fill(ds, "ds"); } catch (System.Data.SqlClient.SqlException ex) { throw new Exception(ex.Message); } ds.rows[0]["password "];//这个就是你要的值 }