sql问题

Question

 strSql = "insert into tb_GovAgentApplication ([companyID],[govAgentID],[title],[Detailinfo],[uploadFileUrl],[releaseDate])  values('"
                    + Encryption.DecryptString(Request.Cookies["companyinfo"]["companyid"]) + "','"
                    + DropDownList1.SelectedValue.ToString() + "','"
                    + Texttitle.Text.Trim().Replace("<", "&lt;").Replace(">", "&gt;") + "','"
                    + TextDetailinfo.Text.Trim().Replace("<", "&lt;").Replace(">", "&gt;") + "','"
                    + fileUrl + "','"
                    + DateTime.Now + "')";
各位大虾能不能看看有什么问题吗?

Answer 1

DateTime.Now是DateTime类型,不是string
改为:
  strSql   =   "insert   into   tb_GovAgentApplication   ([companyID],[govAgentID],[title],[Detailinfo],[uploadFileUrl],[releaseDate])     values('" 
                                        +   Encryption.DecryptString(Request.Cookies["companyinfo"]["companyid"])   +   "','" 
                                        +   DropDownList1.SelectedValue.ToString()   +   "','" 
                                        +   Texttitle.Text.Trim().Replace(" <",   "&lt;").Replace("> ",   "&gt;")   +   "','" 
                                        +   TextDetailinfo.Text.Trim().Replace(" <",   "&lt;").Replace("> ",   "&gt;")   +   "','" 
                                        +   fileUrl   +   "','" 
                                        +   DateTime.Now.ToString() +   "')"; 

Answer 2

就是没有报错,原代码如下:
try
        {
            db.beginTrans();
            strSql = "insert into tb_GovAgentApplication ([govAgentID],[companyID],[title],[Detailinfo],[uploadFileUrl],[releaseDate])  values('"
                    + DropDownList1.SelectedValue.ToString() + "','"
                    + Encryption.DecryptString(Request.Cookies["companyinfo"]["companyid"]) + "','"
                    + Texttitle.Text.Trim().Replace("<", "&lt;").Replace(">", "&gt;") + "','"
                    + TextDetailinfo.Text.Trim().Replace("<", "&lt;").Replace(">", "&gt;") + "','"
                    + fileUrl + "','"
                    + DateTime.Now + "')";
            db.UptRecWithTrans(strSql);
            db.CommitTrans();            PublicFun.alertWindow(Page, "提交成功！");
        }
        catch (Exception ex)
        {
            PublicFun.alertWindow(Page, "修改失败，事务已经回滚！" + ex.ToString());
        }
        Response.Redirect("zwdl.aspx");

Answer 3

设置一个断点看看，看看strSql的值是什么，就清清楚楚的了

Answer 4

Encryption.DecryptString(Request.Cookies["companyinfo"]["companyid"])   
取不到这个值,为什么?

Answer 5

LZ先把try{}catch{}这一块去掉.看看报什么错..

Answer 6

直接把strSql   打印出来 看看sql语句对不对