Solved

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

Posted on 2009-06-29
3
362 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

808 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