我构造的SQL insert 的语句，老出错，请帮忙看一下，语句见内。

Question

insertstr="insert into db(user_id,user_name,e_mail,http,jianjie,oicq,[password],sex,dz,dh) values('"+user_id.Value +"','";
insertstr=insertstr+","+user_name.Value+"',";
insertstr=insertstr+"'"+e_mail.Value+"',";
insertstr=insertstr+"'"+http.Value+"',";
insertstr=insertstr+"'"+jieshao.Value+"',";
insertstr=insertstr+"'"+oicq.Value+"',";
insertstr=insertstr+"'"+password1.Value+"',";
insertstr=insertstr+"'"+select.Value.Trim()+"',";
insertstr=insertstr+"'"+dz.Value+"',";
insertstr=insertstr+dh.Value;
insertstr=insertstr+")";
Response.Write(insertstr);

Answer 1

insert into db(user_id,user_name,e_mail,http,jianjie,oicq,[password],sex,dz,dh) values('c','aa','[email protected]','http://','这家伙很懒 ：',',',',c',',男',',',',')
才对！插入语句错误！

Answer 2

insert into db(user_id,user_name,e_mail,http,jianjie,oicq,[password],sex,dz,dh) value('c','aa','[email protected]','http://','这家伙很懒 ：',',',',c',',男',',',',')

Answer 3

遇到这种情况，最好是把SQL语句运行好以后再放入代码里面！！！