?
Solved

optimistic concurrency

Posted on 2009-04-14
4
Medium Priority
?
696 Views
Last Modified: 2012-05-06
I doing a simple example to learn about optimistic concurrency.  

I have a winform app that displays the employees from the northwind database using a datagridview.  The form has a button click handler to update the datagridview.

In my class file, I have a method called RowUpdated that I want to call to check if there have been any changes to datagridview by another user.  How do I invoke the method so it will check any concurrency issues?

Do I need to add an event handler in the page load?

Thanks for any help.
Employee class file:
 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using OptimisticConcurrencyExample.NorthwindTableAdapters;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;
 
namespace OptimisticConcurrencyExample
{
    class Employee
    {
        private EmployeesTableAdapter _adapter = null;
 
        public EmployeesTableAdapter adapter
        {
            get
            {
                if (_adapter == null)
                {
                    _adapter = new EmployeesTableAdapter();
                }
                return _adapter;
            }
        }
 
        public Northwind.EmployeesDataTable GetEmployees()
        {
            return adapter.GetEmployees();
        }
 
        public void UpdateDataSet(Northwind.EmployeesDataTable dt)
        {
            NorthwindTableAdapters.EmployeesTableAdapter eta = new EmployeesTableAdapter();
            eta.Update(dt);
 
            try
            {
                foreach (Northwind.EmployeesRow currentRow in dt)
                {
                    if (currentRow.HasErrors == true)
                    {
                        Debug.WriteLine(currentRow.EmployeeID + "\n" + currentRow.RowError.ToString());
                    }
                }
            }
            catch (Exception ex)
            {
                // Log errors here.
            }
        }
 
        public void RowUpdated(object sender, SqlRowUpdatedEventArgs e)
        {
            if (e.RecordsAffected == 0)
            {
                e.Row.RowError = "Another user may have recently modified this row.";
                e.Status = UpdateStatus.SkipCurrentRow;
 
            }
        }
 
    }
}
 
winform code-behind:
 
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
 
namespace OptimisticConcurrencyExample
{
    public partial class Form2 : Form
    {
        public Form2()
        {
            InitializeComponent();  
        }
 
        private void Form2_Load(object sender, EventArgs e)
        {
            Employee emp = new Employee();
            gvEmployees.DataSource = emp.GetEmployees();
        }
 
        private void gvEmployees_RowEnter(object sender, DataGridViewCellEventArgs e)
        {
            txtEmployeeID.Text = gvEmployees.Rows[e.RowIndex].Cells[0].Value.ToString();
            txtFirstName.Text = gvEmployees.Rows[e.RowIndex].Cells[2].Value.ToString();
            txtLastName.Text = gvEmployees.Rows[e.RowIndex].Cells[1].Value.ToString();
        }
 
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            Employee emp = new Employee();
            Northwind.EmployeesDataTable dt = new Northwind.EmployeesDataTable();
            dt = (Northwind.EmployeesDataTable)gvEmployees.DataSource;
            emp.UpdateDataSet(dt);
        }
    }
}

Open in new window

0
Comment
Question by:-Dman100-
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 12

Expert Comment

by:wht1986
ID: 24144509
If you are using strong typed datasets, you can just check the "Use Optimistic Concurrency" checkbox of the configuration wizard.  There is also ways of doing it outside the DAL. Examples can be found : http://www.asp.net/Learn/data-access/tutorial-21-cs.aspx

Hope that helps.
0
 

Author Comment

by:-Dman100-
ID: 24148465
Hi wht1986,

Yes, I am using typed datasets.  I checked "Use Optimistic Concurrency" checkbox under the advanced section of the wizard, but when I call the update method with two forms open and make changes in the first form, and then try and update the second form, I get no message alerting me that changes might have already been made and that I'm overwriting changes?

What am I doing incorrectly?
0
 
LVL 12

Accepted Solution

by:
wht1986 earned 2000 total points
ID: 24149341
I have a simple form that has a datagridview bound to BindingSource that uses a typed dataset as its data source.

on form load, i fill the dataset with my table adapter.

I also have a button on my form, that when clicked issues an table adapter update on the dataset.

The typed dataset has optimistic concurncy on.

Irun 2 instances of the application, and edit the same record on both forms.  I click save one one form. and then I click the save on the other form. I get the messagebox saying the underlying data was changed.


        private void Form1_Load(object sender, EventArgs e)
        {
            this.usersTableAdapter.Fill(this.dataSet1.Users);
        }
 
        private void SaveButton_Click(object sender, EventArgs e)
        {
            try
            {
                this.usersTableAdapter.Update(this.dataSet1);
            }
            catch (System.Data.DBConcurrencyException exc)
            {
                MessageBox.Show("It appears another user has changed this record. Please refresh the data before editing.");
            }
        }
    }

Open in new window

0
 

Author Closing Comment

by:-Dman100-
ID: 31570258
Thank you.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

771 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