C#入门教程：数据库查询示例

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
namespace 产品信息
{
    public partial class New : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            String sqlconn = "Server=.;DataBase=GTD;user id=sa;password=123456";
            SqlConnection myConnection = new SqlConnection(sqlconn);
            myConnection.Open();
            SqlCommand myCommand = new SqlCommand("select*from CP", myConnection);
            SqlDataReader myReader;
            myReader = myCommand.ExecuteReader();
            Response.Write("<h3>查询结果</h3>");
            Response.Write("<table border=1 cellspacing=0 cellpadding=2>");
            Response.Write("<tr bgcolor=yellow>");
            for (int i = 0; i < myReader.FieldCount; i++)
            {
                Response.Write("<td>" + myReader.GetName(i) + "</td>");
            }
            Response.Write("</tr>");
            while (myReader.Read())
            {
                Response.Write("<tr>");