Sys.WebForms.PageRequestManagerServerErrorException: 第 1 行: ',' 附近有语法错误。

Question

 for (int g = 0; g < GridViewD.Rows.Count; g++)
                {
                    fn = "ents_comid,  ents_mid,ents_sid, ents_code,ents_pid, ents_qty, ents_wid, ents_price, ents_amount,ents_discount,ents_gamount,  ents_oth1,  ents_rem";
                    fdb = "dbo.Entry_det";
                    string strpre = ((CheckBox)GridViewD.Rows[g].FindControl("CheckBoxpre")).Checked.ToString() == "True" ? "1" : "0";
                    freq = getuser.Strcomid + ",11,'" + ((TextBox)FormView1.FindControl("entm_idTextBox")).Text.Trim().ToString() + "'," + (g + 1) + ",'" + ((TextBox)GridViewD.Rows[g].FindControl("TextBox1")).Text + "'," + ((TextBox)GridViewD.Rows[g].FindControl("TextBox3")).Text + "," + ((DropDownList)GridViewD.Rows[g].FindControl("DropDownListw")).SelectedValue + "," + ((TextBox)GridViewD.Rows[g].FindControl("TextBox4")).Text + "," + (((Label)GridViewD.Rows[g].FindControl("Label4")).Text) + "," + ((TextBox)GridViewD.Rows[g].FindControl("TextBox6")).Text + "," +  ((Label)GridViewD.Rows[g].FindControl("Label8")).Text + ",'"+ ((TextBox)GridViewD.Rows[g].FindControl("TextBox9")).Text + "','" + ((TextBox)GridViewD.Rows[g].FindControl("TextBox11")).Text + "'";
                    DB_operation.insert_data(fn, fdb, freq);
                }调试到这的时候提示语法错误 

Answer 1

估计是你拼接的SQL语句有错
单步调试下，看看得到的SQL是什么

Answer 2

 我知道是sql的问题的 找不到哪个地方啊

Answer 3

调试之后就是这段的错误  > App_Code.0rvldaen.dll!DB_operation.insert_data(string FileName = "ents_comid,  ents_mid,ents_sid, ents_code,ents_pid, ents_qty, ents_wid, ents_price, ents_amount,ents_discount,ents_gamount,  ents_oth1,  ents_rem", string sdb = "dbo.Entry_det", string path = "10000,11,'P20120717-001',1,2118,8,6001,440.00,0.00,0.00,,'',''") 行 42 + 0xb 字节 C#

Answer 4

单步调试一下，看看你拼出来的SQL到底是什么，然后找是那句拼错了顺便说一句，你写的code真的很像乱码

Answer 5

App_Code.0rvldaen.dll!DB_operation.insert_data(string FileName = "ents_comid, ents_mid,ents_sid, ents_code,ents_pid, ents_qty, ents_wid, ents_price, ents_amount,ents_discount,ents_gamount, ents_oth1, ents_rem", string sdb = "dbo.Entry_det", string path = "10000,11,'P20120717-001',1,2118,8,6001,440.00,0.00,0.00,,'',''") 行 42 + 0xb 字节 C#这里两个逗号....是不是多了一个

Answer 6

App_Code.0rvldaen.dll!DB_operation.insert_data(string FileName = "ents_comid, ents_mid,ents_sid, ents_code,ents_pid, ents_qty, ents_wid, ents_price, ents_amount,ents_discount,ents_gamount, ents_oth1, ents_rem", string sdb = "dbo.Entry_det", string path = "10000,11,'P20120717-001',1,2118,8,6001,440.00,0.00,0.00           ,,               '',''") 行 42 + 0xb 字节 C#红色标记部分