连接access数据库及插入数据

连接access数据库用的代码


[复制到剪贴板]CODE:
OleDbConnection conn;//声明一个OledbConnection对象
conn=new OleDbConnection();//建立一个oledbConnection对象
//设定连接字符串ConnectionString
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"
+"Data Source=" + Server.MapPath("user.mdb");
conn.Open();
OleDbCommand Cmd; //声明一个Command对象
//建立Command对象，并且指定SQL语句
string SQLStr;
SQLStr="Select * From reg where userid='" + username.Text + "'";
Cmd=new OleDbCommand(SQLStr,conn);
OleDbDataReader rd; //声明一个DataReader对象
rd=Cmd.ExecuteReader(); //执行SQL指令，并将其结果设定给DataReader
if(rd.Read())
Response.Write("该用户名已经存在,请重新输入!");
else
{
if(password.Text!=repass.Text)
Response.Write("两次密码不相同,请重新输入!");
else
{
step1.Visible=false;
step2.Visible=true;
}
}


插入数据到access数据库


[复制到剪贴板]CODE:
OleDbConnection conn;//声明一个OledbConnection对象
conn=new OleDbConnection();//建立一个oledbConnection对象
//设定连接字符串ConnectionString
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"
+"Data Source=" + Server.MapPath("user.mdb");
conn.Open();
OleDbCommand Cmd; //声明一个Command对象
//建立Command对象，并且指定SQL语句
string SQLStr;
SQLStr="Insert into reg values('" + username.Text + "','";
SQLStr += password.Text + "','" + Email.Text + "','";
SQLStr += addr.Text + "','" +phone.Text + "','";
SQLStr += sex.SelectedItem.Text +"','" + Birth.Text + "')";

Cmd=new OleDbCommand(SQLStr,conn);
Cmd.ExecuteNonQuery(); //执行SQL指令
Response.Write("恭喜,您已经注册成功!");