Update perticular row data into database using Linq To SQl.

Vivek Gupta

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.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel8y ago
Accepted answer
Hi Vikas,

Please share your code to help you..
Vivek Gupta8y ago
no its not working...please g o through my code...
Ramesh Palanivel8y ago
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 Gupta8y ago
Save.Change();
this method new row but i want to update my existing row.
Ramesh Palanivel8y ago
Hi Vikas,

instead of this line,

DMDC.SubmitChanges();

try the below code,

DMDC.SaveChanges();
Vivek Gupta8y ago
hello i just send my code please help me as soon as possible...!!
Vivek Gupta8y ago
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));
}