该用户从未签到
|
| |
6 Q2 X% F, `0 v ?2 j- t* Z往ACCESS 添加数据
/ b4 p# H a. Y6 b3 i" w: [4 m& n3 t6 c' \' R8 W
string 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+"')"; 1 G! M" _. ?+ b' F: S
OleDbConnection myconnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("db1.mdb")); 3 \# g( M( w9 Y& H& ~$ l7 J, n
OleDbCommand mycommand = new OleDbCommand(aaa,myconnection); 2 ?" Y3 s+ j& s8 u5 E$ K" r
mycommand.Connection.Open(); ; p1 K& @% \( Y8 O' Y+ B- G) J+ |
mycommand.ExecuteNonQuery(); 3 c/ i+ a p/ q+ T
mycommand.Connection.Close();
( e4 x3 l8 i. R H, J! N* k6 SResponse.Write("<script language=Javascript>alert('注册成功')</script>");
6 G% J# c6 y9 Y- x' s4 d
' c7 N, ?! G9 B1 V' Q3 T5 m
+ P; a2 m Y$ B% l1 g! v老是说INSERT INTO 语句的语法错误 7 C' k' u$ I, ?! Q$ H5 O0 n, C
检查了N变都没发现哪里错(C#的)
, E& {* Y+ M0 v. x( @ f |
|
|
|