Solved

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

Posted on 2009-06-29
3
361 Views
Last Modified: 2013-11-11
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

0
Comment
Question by:Samantha1667
3 Comments
 
LVL 3

Expert Comment

by:tpsl
ID: 24742573
Which line r u encountering the error
0
 
LVL 15

Accepted Solution

by:
NazoUK earned 50 total points
ID: 24742983
Your casing on the version viewstate variables is different (version and Version), you're probably not getting anything returned when you fetch that variable.
0
 

Author Closing Comment

by:Samantha1667
ID: 31598147
Thank you very very much!
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now