|
| |
; s. {6 d" u W/ _往ACCESS 添加数据7 B" O: ~( K b7 t. n( G
: B5 s$ v1 u% {4 t% e$ S: fstring 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+"')"; : r y( I7 N" Y: m- [+ P8 f
OleDbConnection myconnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("db1.mdb")); ) c+ A: e4 Q2 r. X
OleDbCommand mycommand = new OleDbCommand(aaa,myconnection);
/ C) T4 Z8 H0 x5 S6 }: K3 |mycommand.Connection.Open(); ; A- d( C% g* y
mycommand.ExecuteNonQuery();
8 v4 ]3 I: o+ Q3 Gmycommand.Connection.Close(); ! \* L; ?8 `: E. F* J: v
Response.Write("<script language=Javascript>alert('注册成功')</script>"); $ a& S. e3 K& T" f* @3 w
6 a; G4 T/ q/ K y, y) S
! C& i+ R& [, b% w, Q老是说INSERT INTO 语句的语法错误
2 g# {& V0 v+ H" R* O/ Y检查了N变都没发现哪里错(C#的) - C8 h& {: c5 b! n6 ^5 ^8 M4 W
|
|
|
|