Link to home
Start Free TrialLog in
Avatar of Samantha1667
Samantha1667

asked on

ASP.NET ChangeConflictException; "No row found or changed"

I cant resolve this error.  I'm using Linq to SQL and I can't get this to resolve.  I'm the only one touching this data so it's not a matter of more than one person hitting the data.
using System;
using System.Configuration;
using System.Data;
using System.Data.Linq;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using CPMS_DAL;
 
public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        CPMSDataContext db = new CPMSDataContext();
        tbl_Account Account = db.tbl_Accounts.Single(ua => ua.Company_Name == "Test_Company");
 
        ViewState["AcctID"] = Account.AcctID;
        ViewState["version"] = Account.version;
        ViewState["CreateDate"] = Account.CreateDate;
    }
 
    protected void BtnUpdate_Click(object sender, EventArgs e)
    {
        //Create an Account object and set the properties
        tbl_Account Account = new tbl_Account()
        {
            Company_Name = "Testing_company",
            UpdateDate = DateTime.Now,
            UpdateByID = 55
        };
        Account.AcctID = Convert.ToInt32(ViewState["AcctID"]);
        Account.version = (Binary)ViewState["Version"];
        Account.CreateDate = Convert.ToDateTime(ViewState["CreateDate"]);
        CPMSDataContext db = new CPMSDataContext();
        db.tbl_Accounts.Attach(Account, true);
 
        db.SubmitChanges();
        
    }
   }

Open in new window

Avatar of tpsl
tpsl
Flag of India image

Which line r u encountering the error
ASKER CERTIFIED SOLUTION
Avatar of NazoUK
NazoUK
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Samantha1667
Samantha1667

ASKER

Thank you very very much!