``csharp,protected void Page_Load(object sender, EventArgs e),{, string connectionString = "Data Source=server;Initial Catalog=database;User Id=user;Password=password";, using (SqlConnection con = new SqlConnection(connectionString)), {, string query = "SELECT * FROM Users WHERE UserName='John'";, SqlCommand cmd = new SqlCommand(query, con);, con.Open();, SqlDataReader reader = cmd.ExecuteReader();, while (reader.Read()), {, Response.Write("User ID: " + reader["UserID"].ToString() + "");, }, reader.Close();, },},
``,这段代码连接到一个名为“database”的数据库,从“Users”表中查询用户名为“John”的用户信息,并将用户ID输出到网页上。