连接Access数据库并插入一条数据

时间:2015/10/17 11:05:00来源:互联网 作者:flyso 点击: 934 次

在CS文件里加入using System.Data.OleDb;

//www.flyso.cn
string s1 = str1.Text.ToString();
string s2 = str2.Text.ToString();        
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source="; strConnection += Server.MapPath("#DB.mdb");
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();//打开数据库
OleDbCommand cmd = new OleDbCommand("insert into [xx_table] (s1,s2) values ('" + s1 + "','" + s2 + "')", objConnection);//插入数据
cmd.ExecuteNonQuery();
objConnection.Close();//关闭数据库
Response.Write("<script>alert('添加成功!');location.href='?';</script>");


Copyright © 2005 - 2016 flyso.cn. 飞搜 版权所有 鄂ICP备11002783号-3