ASP.NET

学习ASP.NET,把姓名,性别,QQ号,邮箱写入数据库~
的详细的代码,，说明下这里没有考虑到数据的有效性

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)
{

}
}