SqlConnection conn = new SqlConnection("Data Source=服务器名;Uid=数据库名;pwd=数据库密码;Initial Catalog=数据库名");
conn.Open();
if(conn.State == System.Data.ConnectionState.Open)
{
Response.Write("数据库连接成功!");
}
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT 表的列名 FROM 表名";
string name = (string)cmd.ExecuteScalar();
Response.Write(name);//在页面中显示
conn.Close();