1using System.Data.OleDb;
 2using System;
 3using System.Collections;
 4using System.Configuration;
 5using System.Data;
 6using System.Linq;
 7using System.Web;
 8using System.Web.Security;
 9using System.Web.UI;
10using System.Web.UI.HtmlControls;
11using System.Web.UI.WebControls;
12using System.Web.UI.WebControls.WebParts;
13using System.Xml.Linq;
14
15namespace Mypb
16...{
17    public partial class add : System.Web.UI.Page
18    ...{
19        protected void Page_Load(object sender, EventArgs e)
20        ...{
21            this.Title = "添加新纪录";
22            TextBox1.Focus();
23        }
24
25        protected void Button2_Click(object sender, EventArgs e)
26        ...{
27            OleDbConnection conn = new OleDbConnection();
28            conn.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;" + "Data Source = " + Server.MapPath("App_Data/Myphonebook.mdb");
29            //string strVal = TextBox1.Text + "," + TextBox2.Text.ToString() + "," + TextBox3.Text.ToString();
30            string strVal = "'" + TextBox1.Text +"'," + "'"+ TextBox2.Text + "'," +"'"+ TextBox3.Text+"'";
31            string strIns = "insert into 通信录(姓名,电话,Email) values(" + strVal + ")";
32            OleDbCommand insCom = new OleDbCommand(strIns, conn);
33            OleDbDataAdapter da = new OleDbDataAdapter();
34            conn.Open();
35            da.InsertCommand = insCom;
36            da.InsertCommand.ExecuteNonQuery();
37            conn.Close();
38            Response.Write("<script language=javascript>alert('新纪录添加成功，请单击“返回”回到主页面！');</script>");
39        }
40
41        protected void Button1_Click(object sender, EventArgs e)
42        ...{
43            Response.Redirect("default.aspx");
44        }
45    }
46}
47