无法插入。不显示任何错误，但也不插入 [英] Not able to insert. Doesn't show any errors but doesn't insert as well

问题描述

这是我的插入声明。记录未插入但也未显示错误。我很困惑。

Hi this is my insert statement. Records are not inserting but no errors showing also. I am confused.

protected void btn_add_Click(object sender, EventArgs e)
    {
        

            if (btn_add.Text == "Submit")
            {
                System.Collections.Hashtable ht = (System.Collections.Hashtable)Session["UserDetails"];
                Int64 UsrId = (Int64)ht["UserID"];
                string JBoltNos = Convert.ToString(txt_JBoltNos.Text.Trim());
                string JBoltNos_desc = Convert.ToString(txt_JBoltNosDesc.Text.Trim());
                string JBoltDia = Convert.ToString(txt_JBoltDia.Text.Trim());
                string JBoltDia_desc = Convert.ToString(txt_JBoltDiaDesc.Text.Trim());
                string YieldStress = Convert.ToString(txt_YieldStress.Text.Trim());
                string YieldStress_desc = Convert.ToString(txt_YieldStressDesc.Text.Trim());
                string PitchCircleDia = Convert.ToString(txt_PitchCircleDia.Text.Trim());
                string PitchCircleDia_desc = Convert.ToString(txt_PitchCircleDiaDesc.Text.Trim());
                string BoltLen = Convert.ToString(txt_BoltLen.Text.Trim());
                string BoltLen_desc = Convert.ToString(txt_BoltLenDesc.Text.Trim());
                string ProjectedBLen = Convert.ToString(txt_ProjectedBLen.Text.Trim());
                string ProjectedBLen_desc = Convert.ToString(txt_ProjectedBLenDesc.Text.Trim());
                string Cost = Convert.ToString(txt_Cost.Text.Trim());
                string Product_Type = Convert.ToString(dd_Product_Type.SelectedValue.Trim());
                string Bolt_Type = Convert.ToString(dd_Bolt_Type.SelectedValue.Trim());
                string ED_ACC = chk_ED_ACC.Checked ? "True" : "False"; 
                string UNIT_OF_MEASUREMENT = Convert.ToString(txt_UNIT_OF_MEASUREMENT.Text.Trim());
                string IsActive = chk_Active.Checked ? "True" : "False";
                string CreatedBy = Convert.ToString(UsrId);
 string filename = Path.GetFileName(fileuploadimages.PostedFile.FileName);
                fileuploadimages.SaveAs(Server.MapPath("~/Images/Foundation Bolt/" + filename));

                try
                {
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["valmont"].ToString());
                    con.Open();
                    SqlCommand cmd = new SqlCommand("Insert into DEF_FONDATION_BOLT_MST(JBoltNos,JBoltNos_desc,JBoltDia,JBoltDia_desc,YieldStress,YieldStress_desc,PitchCircleDia,PitchCircleDia_desc,BoltLen,BoltLen_desc,ProjectedBLen,ProjectedBLen_desc,Cost,CreatedBy,Product_Type,Bolt_Type,ED_ACC,UNIT_OF_MEASUREMENT,IsActive,ImagePath) values(@JBoltNos,@JBoltNos_desc,@JBoltDia,@JBoltDia_desc,@YieldStress,@YieldStress_desc,@PitchCircleDia,@PitchCircleDia_desc,@BoltLen,@BoltLen_desc,@ProjectedBLen,@ProjectedBLen_desc,@Cost,@CreatedBy,@Product_Type,@Bolt_Type,@ED_ACC,@UNIT_OF_MEASUREMENT,@IsActive,@ImagePath", con);

                    cmd.Parameters.AddWithValue("@JBoltNos", JBoltNos);
                    cmd.Parameters.AddWithValue("@JBoltNos_desc", JBoltNos_desc);
                    cmd.Parameters.AddWithValue("@JBoltDia", JBoltDia);
                    cmd.Parameters.AddWithValue("@JBoltDia_desc", JBoltDia_desc);
	                cmd.Parameters.AddWithValue("@YieldStress", YieldStress);
                    cmd.Parameters.AddWithValue("@YieldStress_desc", YieldStress_desc);
                    cmd.Parameters.AddWithValue("@PitchCircleDia", PitchCircleDia);
                    cmd.Parameters.AddWithValue("@PitchCircleDia_desc", PitchCircleDia_desc);
                    cmd.Parameters.AddWithValue("@BoltLen", BoltLen);
                    cmd.Parameters.AddWithValue("@BoltLen_desc", BoltLen_desc);
                    cmd.Parameters.AddWithValue("@ProjectedBLen", ProjectedBLen);
                    cmd.Parameters.AddWithValue("@ProjectedBLen_desc", ProjectedBLen_desc);
                    cmd.Parameters.AddWithValue("@Cost", Cost);
                    cmd.Parameters.AddWithValue("@CreatedBy", CreatedBy);
                    cmd.Parameters.AddWithValue("@Product_Type", Product_Type);
                    cmd.Parameters.AddWithValue("@Bolt_Type", Bolt_Type);
                    cmd.Parameters.AddWithValue("@ED_ACC", ED_ACC);
                    cmd.Parameters.AddWithValue("@UNIT_OF_MEASUREMENT", UNIT_OF_MEASUREMENT);
                    cmd.Parameters.AddWithValue("@IsActive", IsActive);
                    cmd.Parameters.AddWithValue("@ImagePath", "~/Images/Bracket Type/" + filename);
                    cmd.ExecuteNonQuery();
                    con.Close();

请在此处找到该表的屏幕截图。



https://plus.google。 com / photos / 105102745662527540029 / albums / 6186819764271745713/6186819768105060962？pid = 6186819768105060962& oid = 105102745662527540029 [ ^ ]

推荐答案

我会说该声明会导致错误，因为你错过了值的结束括号。



尝试使用

I would say that the statement causes an error since you're missing an ending parenthesis for the values.

Try using

SqlCommand cmd = new SqlCommand("Insert into DEF_FONDATION_BOLT_MST(JBoltNos,JBoltNos_desc,JBoltDia,JBoltDia_desc,YieldStress,YieldStress_desc,PitchCircleDia,PitchCircleDia_desc,BoltLen,BoltLen_desc,ProjectedBLen,ProjectedBLen_desc,Cost,CreatedBy,Product_Type,Bolt_Type,ED_ACC,UNIT_OF_MEASUREMENT,IsActive,ImagePath) values(@JBoltNos,@JBoltNos_desc,@JBoltDia,@JBoltDia_desc,@YieldStress,@YieldStress_desc,@PitchCircleDia,@PitchCircleDia_desc,@BoltLen,@BoltLen_desc,@ProjectedBLen,@ProjectedBLen_desc,@Cost,@CreatedBy,@Product_Type,@Bolt_Type,@ED_ACC,@UNIT_OF_MEASUREMENT,@IsActive,@ImagePath)", con);

如果异常未正确显示，检查您当前有错误处理的代码，它不会丢弃信息。

Also if the exception isn't shown properly, check the code you currently have for error handling that it's not throwing away the information.

这篇关于无法插入。不显示任何错误，但也不插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！