Click here to Skip to main content
15,892,005 members
Please Sign up or sign in to vote.
1.20/5 (2 votes)
Hi this is my insert statement. Records are not inserting but no errors showing also. I am confused.

C#
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();


Please find the screenshot of the table here.

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

1 solution

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

Try using
C#
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.
 
Share this answer
 
Comments
Member 9017207 25-Aug-15 2:31am    
Thanks a lot. ending parenthesis was causing the problem.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900