连接access数据库及插入数据

//连接access数据库用的代码

 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数据库

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( " 恭喜,您已经注册成功! " );

转载于:https://www.cnblogs.com/pageantry/archive/2007/05/16/748146.html