| 6 _" A$ u3 k- M: H2 g$ f
往ACCESS 添加数据
( J4 \ C8 Y9 ] p
$ M( ]5 ?0 ~) ]! J: M; N2 Y. _% Cstring aaa="insert into zhuce(a_name,a_pwd,a_apwd,a_e-mail,a_tel) values('"+TextBox1.Text+",'"+TextBox2.Text+"','"+TextBox3.Text+"','"+TextBox4.Text+"','"+TextBox5.Text+"')";
8 a- K/ Z( R U: k5 \! I0 oOleDbConnection myconnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("db1.mdb"));
% n% d- C; g" q" U3 ? OleDbCommand mycommand = new OleDbCommand(aaa,myconnection);
% e% R K$ s" E# X: E" p+ B# W+ Wmycommand.Connection.Open(); $ I9 j8 n$ e7 ^
mycommand.ExecuteNonQuery();
* Q1 G. Q4 z2 X4 t# h* _mycommand.Connection.Close(); % H* ?, k/ A. w1 l' e2 H
Response.Write("<script language=Javascript>alert('注册成功')</script>"); 9 Q0 s, Z, F+ P' P: h. G7 K
% S, [( S4 O, N: M. z" t
. H- t& [( y* L9 u7 e$ b, Y老是说INSERT INTO 语句的语法错误 5 \/ J( }0 u! |2 P7 k
检查了N变都没发现哪里错（C#的）
2 J# k. d/ x; T: D/ i |
|