Click here to Skip to main content
15,881,248 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hi, I am able to insert into the webform, but not able to update. No error is showing. BUt it's not updating as well.

C#
if (btn_add.Text == "Submit")
        {
            string BracketSuspensionType = Convert.ToString(txt_BracketSuspensionType.Text.Trim());
            string PoleTypeID = Convert.ToString(dd_PoleTypeID.SelectedValue.Trim());
            string Status = chk_Active.Checked ? "True" : "False";
            System.Collections.Hashtable ht = (System.Collections.Hashtable)Session["UserDetails"];
            Int64 UsrId = (Int64)ht["UserID"];
            string CreatedBy = Convert.ToString(UsrId);
            //string CreatedOn = DateTime.Now;
            string filename = Path.GetFileName(fileuploadimages.PostedFile.FileName);
            fileuploadimages.SaveAs(Server.MapPath("~/Images/Bracket Type/" + filename));
            try
            { 
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["valmont"].ToString());
            con.Open();
            SqlCommand cmd = new SqlCommand("Insert into DEF_BRACKET_ACCESSORIES_MST(BracketSuspensionType,PoleTypeID,Status,CreatedBy,ImagePath) values(@BracketSuspensionType,@PoleTypeID,@Status,@CreatedBy,@ImagePath)", con);

            cmd.Parameters.AddWithValue("@BracketSuspensionType", BracketSuspensionType);
            cmd.Parameters.AddWithValue("@PoleTypeID", PoleTypeID);
            cmd.Parameters.AddWithValue("@Status", Status);
            cmd.Parameters.AddWithValue("@CreatedBy", CreatedBy);
            //cmd.Parameters.AddWithValue("@CreatedOn", CreatedOn);
            cmd.Parameters.AddWithValue("@ImagePath", "~/Images/Bracket Type/" + filename);
            cmd.ExecuteNonQuery();
            con.Close();
           }
else if (btn_add.Text == "Update")

{
grv_BracketAccessories.EditIndex = -1;
            string AccessoryID = Convert.ToString(txtAccessoryID.Text);
            //string AccessoryID = txtAccessoryID.Text;
            string BracketSuspensionType = Convert.ToString(txt_BracketSuspensionType.Text.Trim());
            string PoleTypeID = Convert.ToString(dd_PoleTypeID.SelectedValue.Trim());
            string Status = chk_Active.Checked ? "True" : "False";
            System.Collections.Hashtable ht = (System.Collections.Hashtable)Session["UserDetails"];
            Int64 UsrId = (Int64)ht["UserID"];
            string CreatedBy = Convert.ToString(UsrId);
            //string CreatedOn = DateTime.Now;
            string filename = Path.GetFileName(fileuploadimages.PostedFile.FileName);
            fileuploadimages.SaveAs(Server.MapPath("~/Images/Bracket Type/" + filename));

            try
            {
                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["valmont"].ToString());
                con.Open();
                //SqlCommand cmd = new SqlCommand("Update DEF_BRACKET_ACCESSORIES_MST(BracketSuspensionType,PoleTypeID,Status,CreatedBy,ImagePath) values(@BracketSuspensionType,@PoleTypeID,@Status,@CreatedBy,@ImagePath)", con);
                SqlCommand cmd = new SqlCommand("Update DEF_BRACKET_ACCESSORIES_MST set BracketSuspensionType=@BracketSuspensionType,PoleTypeID=@PoleTypeID,Status=@Status,CreatedBy=@CreatedBy,ImagePath=@ImagePath WHERE AccessoryID=@AccessoryID", con);
                cmd.Parameters.AddWithValue("@BracketSuspensionType", BracketSuspensionType);
                cmd.Parameters.AddWithValue("@PoleTypeID", PoleTypeID);
                cmd.Parameters.AddWithValue("@Status", Status);
                cmd.Parameters.AddWithValue("@CreatedBy", CreatedBy);
                //cmd.Parameters.AddWithValue("@CreatedOn", CreatedOn);
                cmd.Parameters.AddWithValue("@ImagePath", "~/Images/Bracket Type/" + filename);
                cmd.Parameters.AddWithValue("@AccessoryID", AccessoryID);
                cmd.ExecuteNonQuery();
                con.Close();
}


Here is the table:

SQL
CREATE TABLE [dbo].[DEF_BRACKET_ACCESSORIES_MST](
	[AccessoryID] [bigint] IDENTITY(1,1) NOT NULL,
	[BracketSuspensionType] [varchar](70) NOT NULL,
	[Status] [bit] NOT NULL,
	[CreatedBy] [bigint] NULL,
	[CreatedOn] [datetime] NULL,
	[UpdatedBy] [bigint] NULL,
	[UpdatedOn] [datetime] NULL,
	[PoleTypeID] [bigint] NOT NULL,
	[column1] [varchar](100) NULL,
	[column2] [varchar](100) NULL,
	[column3] [varchar](100) NULL,
	[ImagePath] [varchar](max) NULL,
 CONSTRAINT [PK__DEF_BRAC__3214EC270D7A0286] PRIMARY KEY CLUSTERED 
(
	[AccessoryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


Here AccessoryID is the primary key.
And based on that updating should be done.
Posted
Comments
Arasappan 20-Aug-15 2:37am    
use the breakpoint,and note it get all data
Sreekanth Mothukuru 20-Aug-15 2:39am    
What did you fingd while debugging the code? Try to use SQL Profiler to track the query that gets executed.
Mayank Vashishtha 20-Aug-15 3:25am    
Does your button "btn_add" text changes when you press it. Cause as I can see you are using only one button. Check that first whether the control ever reaches else part?
Sinisa Hajnal 21-Aug-15 2:25am    
Check that your code really gets executed. Check that accessoryID gets set.

Change this: string AccessoryID = Convert.ToString(txtAccessoryID.Text);
to string AccessoryID = txtAccessoryID.Text.Trim - it is already string you don't haveto convert it. It would make sense if that was an integer. I would suggest you set AccessoryID as int in your code since that type is in the database.

Check the overloads of addwithvalue to see if one of them allows defining types of the parameters.
Member 9017207 21-Aug-15 2:51am    
still not updating

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