//连接access数据库用的代码
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 + "')";
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
Cmd=new OleDbCommand(SQLStr,conn);
Cmd.ExecuteNonQuery(); //执行SQL指令
Response.Write("恭喜,您已经注册成功!");
1
OleDbConnection conn;//声明一个OledbConnection对象
2
conn=new OleDbConnection();//建立一个oledbConnection对象
3
//设定连接字符串ConnectionString
4
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"
5
+"Data Source=" + Server.MapPath("user.mdb");
6
conn.Open();
7
OleDbCommand Cmd; //声明一个Command对象
8
//建立Command对象,并且指定SQL语句
9
string SQLStr;
10
SQLStr="Select * From reg where userid='" + username.Text + "'";
11
Cmd=new OleDbCommand(SQLStr,conn);
12
OleDbDataReader rd; //声明一个DataReader对象
13
rd=Cmd.ExecuteReader(); //执行SQL指令,并将其结果设定给DataReader
14
if(rd.Read())
15
Response.Write("该用户名已经存在,请重新输入!");
16
else
17
{
18
if(password.Text!=repass.Text)
19
Response.Write("两次密码不相同,请重新输入!");
20
else
21
{
22
step1.Visible=false;
23
step2.Visible=true;
24
}
25
}
//插入数据到access数据库![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
23
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
24
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
25
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)