ASP.NET怎样将注册信息写入Access【转】?

专门给你写了个,你看一下,说明下这里没有考虑到数据的有效性,需要的话自己加上。

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.OleDb; //这里要引用OleDb空间

public partial class Default4 : System.Web.UI.Page

{

//数据库连接字符串

static string strCon = @"provider = Microsoft.Jet.OLEDB.4.0;Data source = C:\Documents and Settings\Administrator\桌面\db1.mdb";

//申明连接数据源的对象和对数据源进行操作的对象

OleDbConnection con = new OleDbConnection(strCon);

OleDbCommand cmd = new OleDbCommand();

//点击按钮添加记录

protected void Button1_Click(object sender, EventArgs e)

{

string name = TextBox1.Text.Trim(); //姓名

string sex = TextBox2.Text.Trim(); //性别

string QQ = TextBox3.Text.Trim(); //QQ

string email = TextBox4.Text.Trim(); //Email

//要插入记录的sql语句

string insertText = "insert into info(姓名,性别,QQ,邮箱) values('" + name + "','" + sex + "','" + QQ + "','" + email + "')";

//数据源打开

con.Open();

//设置操作对象的数据源

cmd.Connection = con;

//要执行的SQL语句

cmd.CommandText = insertText;

//执行操作

cmd.ExecuteNonQuery();

//数据源关闭

con.Close();

}

protected void Page_Load(object sender, EventArgs e)

{

}

}