.net插入语句(Access)语法错误,哪里错了啊??

[复制链接]
查看11 | 回复1 | 2009-4-17 16:38:11 | 显示全部楼层 |阅读模式
str_insert = "insert into work(class_1,class_2,salary,zp_num,"
+ "nature,area,educational,experience,describe,demand,star_time,stop_time,add_time,add_ip,code,user_name,company_name)"
+ "values('" + dr_class.Text + "','" + txt_class_2.Text + "','" + dr_salary.Text + "','" + txt_zp_num.Text + "',"
+ "'" + dr_nature.Text + "','" + str_area + "','" + dr_educational.Text + "','" + txt_experience.Text + "',"
+ "'" + txt_describe.Text + "','" + txt_demand.Text + "','" + DateTime.Now + "','" + Convert.ToDateTime(str_time) + "',"
+ "'" + DateTime.Now + "','" + Page.Request.UserHostAddress.ToString() + "','" + DateTime.Now.ToString().Replace("-", "").Replace(" ", "").Replace(":", "") + Page.Request.UserHostAddress.ToString().Replace(".", "") + "',"
+ "'"+lb_session.Text+"','" + lb_company_name.Text + "')";

回复

使用道具 举报

千问 | 2009-4-17 16:38:11 | 显示全部楼层
我发现一个错误,values前面要加一个空格! 没有空格的话,sql语句就是insert into work(...)values(...),这是错误的,正确的是:insert into work(...) values(...)其他地方就看你的数据类型是不是一致了?...
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行