HTML

客户端HTML： HTML + 控件 + vbScript/JavaScript
服务器端HTML：

1. JSP
2. PHP 开源的
3. ASP 微软的 ASP.Net

连接数据库

ADO.net 连接数据库的两种框架：

1）Connection -> Command -> DataReader -> GridView
连接 工具 内存对象 屏幕载体
2）Connection -> DataAdapter -> DataSet -> GridView

路径逻辑： 首先建立与数据库的连接，然后借助工具将数据导入内存对象，最后通过屏幕载体显示出来。

框架

显示数据库

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.Odbc;
using System.Data.OleDb;


using System.Data.Odbc;  //连接任何支持ODBC接口的数据库
using System.Data.OleDb; //连接微软桌面数据库 access execl
using System.Data.SqlClient; //sql server
using System.Data.Oracle;  //连接甲骨文数据库

namespace WebApplication3
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
        if (IsPostBack != true)
            {
            OleDbConnection cn = new OleDbConnection();
            cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\\dbtest1\\database1.accdb";
            cn.Open();
            OleDbCommand cmd = new OleDbCommand("select * from 表1", cn);
            OleDbDataReader dr = cmd.ExecuteReader();
            GridView1.DataSource = dr;
            GridView1.DataBind();
            dr.Close();
            cn.Close();
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            OleDbConnection connection = new OleDbConnection();
            connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\dbtest1\\database1_mdb.MDB";
            connection.Open();

            OleDbCommand cmd = new OleDbCommand("select * from 表2",connection);
            OleDbDataReader dataReader = new OleDbDataReader();
            GridView1.DataSource = dataReader;
            GridView1.DataBind();
            dataReader.Close();
            connection.Close();
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            OdbcConnection cn = new OdbcConnection();
            cn.ConnectionString = "DSN=xxx";
            cn.Open();

            string queryStr = "select * from 表1 where 学号 like '%" + TextBox1.Text + "%'";//SQL命令，如输入f，则含有f的都会被输出
            OdbcCommand cmd = new OdbcCommand(queryStr, cn);
            OdbcDataReader dr = cmd.ExecuteReader();
            GridView1.DataSource = dr;
            GridView1.DataBind();

            dr.Close();
            cn.Close();
        }

        protected void Button3_Click(object sender, EventArgs e)
        {
            OdbcConnection cn = new OdbcConnection();
            cn.ConnectionString = "DSN=xxx";
            cn.Open();

            string queryStr = "select * from 表1 where 学号 like '%" + TextBox1.Text + "%'";
            OdbcDataAdapter ad = new OdbcDataAdapter(queryStr, cn);
            DataSet ds = new DataSet();
            ad.Fill(ds, "table1");

            GridView1.DataSource = ds.Tables["table1"];
            GridView1.DataBind();

            cn.Close();
        }

        protected void Button4_Click(object sender, EventArgs e)
        {
            OdbcConnection cn = new OdbcConnection();
            cn.ConnectionString = "DSN=xxx";
            cn.Open();

            //增加一个新行
            string querystr = "select * from 表2";
            OdbcDataAdapter ad = new OdbcDataAdapter(querystr, cn);
            DataSet ds = new DataSet();
            ad.Fill(ds, "table2");

            DataTable dt = ds.Tables["table2"];
            DataRow newRow = dt.NewRow();
            newRow["教师编号"] = TextBox2.Text;
            newRow["姓名"] = TextBox3.Text;
            newRow["体重"] = TextBox4.Text;
            newRow["年龄"] = TextBox5.Text;
            dt.Rows.Add(newRow);//相当于建立一个新表，再覆盖原来的表
            ad.Update(ds, "table2");

            //重新显示增加新行后的表
            OdbcCommand cmd = new OdbcCommand("select * from 表2", cn);
            OdbcDataReader dr = cmd.ExecuteReader();
            GridView1.DataSource = dr;
            GridView1.DataBind();
            
            dr.Close();
            cn.Close();
        }
    }
}