Update perticular row data into database using Linq To SQl.

Question

i have a page on edit button and i pass row value in through query string.all the vale of row data fecth on a perticular page where i want to perform update action on click event of a update button. i write sql query but its not work. please guys help me.... if any query regadings plz comment on reply section.

Ramesh Palanivel · Answer

Hi Vikas, Please share your code to help you..

Vivek Gupta · Answer

no its not working...please g o through my code...

Ramesh Palanivel · Answer

Hi Vikas, The save changes automattiy will update your entity. You can use save changes for insert,update and delete as well.Try it and let me know.

Vivek Gupta · Answer

Save.Change(); this method new row but i want to update my existing row.

Ramesh Palanivel · Answer

Hi Vikas, instead of this line, DMDC.SubmitChanges(); try the below code, DMDC.SaveChanges();

Vivek Gupta · Answer

hello i just send my code please help me as soon as possible...!!

Vivek Gupta · Answer

private void SaveData(int jobid) { dcMainAppDataContext DMDC = new dcMainAppDataContext(); Jobpost jobobj = (from al in DMDC.Jobposts where al.JobID == jobid select al).FirstOrDefault(); Trace.Warn("true", "jobobj"); jobobj.JobCode = txtjobcode.Text.Trim(); if (RdoOpen.Checked) { jobobj.Jobstatus = "Open"; } else { jobobj.Jobstatus = "Close"; } jobobj.Position = txtposition.Text.Trim(); jobobj.Locations = txtlocations.Text.Trim(); if (rdomale.Checked) { jobobj.Gender = "Male"; } else if (rdofemale.Checked) { jobobj.Gender = "Female"; } else if (rdoany.Checked) { jobobj.Gender = "Any"; } jobobj.Experiance = txtexperience.Text.Trim(); jobobj.Remuneraions = txtRemunertions.Text.Trim(); jobobj.Qulifications = txtqulifications.Text.Trim(); jobobj.keyskills = KSSkills.Text.Trim(); jobobj.JobDescriptions = JDEditorControl1.Text.Trim(); DMDC.SubmitChanges(); } protected void btnupdate_Click(object sender, EventArgs e) { string jdid= Request.QueryString["JOBID"]; if (jdid != null) { SaveData(Convert.ToInt32(jdid)); }