看看,我的SQL语句错在哪里?
protected void btn_submit_Click(object sender, EventArgs e)
{
string CnnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + Server.MapPath( "feedback.mdb ");
OleDbConnection con = new OleDbConnection(CnnString);
con.Open();
try
{
OleDbCommand cmd = new OleDbCommand( "insert into feedback(name,sex,identity,address,xueli,jobUnit,duty,tel,mobile,marriage,child,food,city,info,dish,resume,invest,shopArea,intent,market,populace,industry,cooperate,mode,likeMode,proposer,time) values(@name,@sex,@identity,@address,@xueli,@jobUnit,@duty,@tel,@mobile,@marriage,@child,@food,@city,@info,@dish,@resume,@invest,@shopArea,@intent,@market,@populace,@industry,@cooperate,@mode,@likeMode,@proposer,@time) ", con);
OleDbParameter para = new OleDbParameter( "@name ", OleDbType.VarChar, 50);
para.Value = this.tbx_name.Text.Trim();
cmd.Parameters.Add(para);
para = new OleDbParameter( "@sex ", OleDbType.VarChar, 10);
para.Value = this.tbx_sex.Text.Trim();
cmd.Parameters.Add(para);
para = new OleDbParameter( "@identity ", OleDbType.VarChar, 50);
para.Value = this.tbx_identity.Text.Trim();
cmd.Parameters.Add(para);
para = new OleDbParameter( "@address ", OleDbType.VarChar, 50);
para.Value = this.tbx_address.Text.Trim();
cmd.Parameters.Add(para);
para = new OleDbParameter( "@xueli ", OleDbType.VarChar, 30);
para.Value = this.tbx_xueli.Text.Trim();
cmd.Parameters.Add(para);