Concurrency Error in Update.

S

Stacey Feldman

Below, is a sample code I have been using to test my application. I have
been tearing my hair out with this. For the code below, I used the
OleDbDataAdapter config that is generated by the VS.NET Adapter Config
wizard.

When Update is called on the adapter, I get a concurrency error. There is NO
ONE else using the database. There have been no changes to the underlying
data. I know something is wrong with the command

This has happened to others and they have posted to newsgroups, but I have
not found any answers there....does anyone know what is going on???

Please help!



Stacey





============================================================================
======



using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Data.OleDb;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using Thairidgebackdog.Applications.TRDCommunity.TRDUpdate;

namespace Thairidgebackdog.Applications.TRDCommunity

{

/// <summary>

/// Summary description for tester.

/// </summary>

public class tester : System.Web.UI.Page

{

protected System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;

protected System.Data.OleDb.OleDbCommand oleDbSelectCommand1;

protected System.Data.OleDb.OleDbCommand oleDbInsertCommand1;

protected System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;

protected System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;

protected System.Data.OleDb.OleDbConnection oleDbConnection1;

protected System.Data.DataSet ds;

protected System.Web.UI.WebControls.Button Button1;


private void Page_Load(object sender, System.EventArgs e)

{


//if(!this.IsPostBack)

{ oleDbConnection1.Open();

oleDbDataAdapter1.SelectCommand.Parameters["OwnerID"].Value =
"2e31638826a94193a4b3b60689e4999f";

oleDbDataAdapter1.SelectCommand.Parameters["OwnerID"].SourceColumn =
"OwnerID";

oleDbDataAdapter1.SelectCommand.Parameters["OwnerID"].SourceVersion =
System.Data.DataRowVersion.Original;



oleDbDataAdapter1.Fill(ds,"TRDMembers");


}



}


public void Update()

{

DataRow tr = ds.Tables["TRDMembers"].Rows[0];

tr.BeginEdit();

tr["Email"] = "(e-mail address removed)";

tr.EndEdit();

oleDbDataAdapter1.RowUpdated += new
OleDbRowUpdatedEventHandler(this.RowUpdated);


DataSet changes = ds.GetChanges();

if (changes != null)

{

//oleDbDataAdapter1.UpdateCommand.Parameters["OwnerID"].Value =
"2e31638826a94193a4b3b60689e4999f";

// oleDbDataAdapter1.UpdateCommand.Parameters["OwnerID"].SourceColumn =
"OwnerID";

//oleDbDataAdapter1.UpdateCommand.Parameters["OwnerID"].SourceVersion =
System.Data.DataRowVersion.Original;

oleDbDataAdapter1.Update(changes,"TRDMembers");


//Don't commit if errors occured

if (!changes.HasErrors)

{

//Commit the txn

//tran.Commit();

//Commit the changes to the dataset

//ds.AcceptChanges();

}

else

{

//Dataset has errors - roll back the transaction

//ds.RejectChanges();

//tran.Rollback();

}


}

// Put user code to initialize the page here

}

#region Web Form Designer generated code

override protected void OnInit(EventArgs e)

{

//

// CODEGEN: This call is required by the ASP.NET Web Form Designer.

//

InitializeComponent();

base.OnInit(e);

}


/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();

this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();

this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();

this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();

this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();

this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();

this.ds = new System.Data.DataSet();

((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();

this.Button1.Click += new System.EventHandler(this.Button1_Click);

//

// oleDbDataAdapter1

//

this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;

this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;

this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;

this.oleDbDataAdapter1.TableMappings.AddRange(new
System.Data.Common.DataTableMapping[] {

new System.Data.Common.DataTableMapping("Table", "TRDMembers", new
System.Data.Common.DataColumnMapping[] {

new System.Data.Common.DataColumnMapping("City", "City"),

new System.Data.Common.DataColumnMapping("Country", "Country"),

new System.Data.Common.DataColumnMapping("Email", "Email"),

new System.Data.Common.DataColumnMapping("FirstName", "FirstName"),

new System.Data.Common.DataColumnMapping("IsBreeder", "IsBreeder"),

new System.Data.Common.DataColumnMapping("LastName", "LastName"),

new System.Data.Common.DataColumnMapping("State", "State")})});

this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;

//

// oleDbSelectCommand1

//

this.oleDbSelectCommand1.CommandText = "SELECT City, Country, Email,
FirstName, IsBreeder, LastName, State, OwnerID FROM " +

"TRDMembers WHERE (OwnerID = ?)";

this.oleDbSelectCommand1.Connection = this.oleDbConnection1;

this.oleDbSelectCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("OwnerID",
System.Data.OleDb.OleDbType.VarWChar, 100, "OwnerID"));

//

// oleDbInsertCommand1

//

this.oleDbInsertCommand1.CommandText = "INSERT INTO TRDMembers(City,
Country, Email, FirstName, IsBreeder, LastName, Stat" +

"e, OwnerID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";

this.oleDbInsertCommand1.Connection = this.oleDbConnection1;

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("City",
System.Data.OleDb.OleDbType.VarWChar, 50, "City"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Country",
System.Data.OleDb.OleDbType.Integer, 0,
System.Data.ParameterDirection.Input, false, ((System.Byte)(10)),
((System.Byte)(0)), "Country", System.Data.DataRowVersion.Current, null));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Email",
System.Data.OleDb.OleDbType.VarWChar, 50, "Email"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("FirstName",
System.Data.OleDb.OleDbType.VarWChar, 50, "FirstName"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("IsBreeder",
System.Data.OleDb.OleDbType.Boolean, 2, "IsBreeder"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("LastName",
System.Data.OleDb.OleDbType.VarWChar, 50, "LastName"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("State",
System.Data.OleDb.OleDbType.VarWChar, 2, "State"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("OwnerID",
System.Data.OleDb.OleDbType.VarWChar, 100, "OwnerID"));

//

// oleDbUpdateCommand1

//

this.oleDbUpdateCommand1.CommandText = @"UPDATE TRDMembers SET City = ?,
Country = ?, Email = ?, FirstName = ?, IsBreeder = ?, LastName = ?, State =
? WHERE (OwnerID = ?) AND (City = ? OR ? IS NULL AND City IS NULL) AND
(Email = ?) AND (FirstName = ?) AND (IsBreeder = ?) AND (LastName = ?) AND
(State = ? OR ? IS NULL AND State IS NULL)";

this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("City",
System.Data.OleDb.OleDbType.VarWChar, 50, "City"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Country",
System.Data.OleDb.OleDbType.Integer, 0,
System.Data.ParameterDirection.Input, false, ((System.Byte)(10)),
((System.Byte)(0)), "Country", System.Data.DataRowVersion.Current, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Email",
System.Data.OleDb.OleDbType.VarWChar, 50, "Email"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("FirstName",
System.Data.OleDb.OleDbType.VarWChar, 50, "FirstName"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("IsBreeder",
System.Data.OleDb.OleDbType.Boolean, 2, "IsBreeder"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("LastName",
System.Data.OleDb.OleDbType.VarWChar, 50, "LastName"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("State",
System.Data.OleDb.OleDbType.VarWChar, 2, "State"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("OwnerID",
System.Data.OleDb.OleDbType.VarWChar, 100, "OwnerID"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_OwnerID",
System.Data.OleDb.OleDbType.VarWChar, 100,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "OwnerID", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Email",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Email", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_FirstName",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "FirstName", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_IsBreeder",
System.Data.OleDb.OleDbType.Boolean, 2,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "IsBreeder", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_LastName",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "LastName", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State",
System.Data.OleDb.OleDbType.VarWChar, 2,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State1",
System.Data.OleDb.OleDbType.VarWChar, 2,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

//

// oleDbDeleteCommand1

//

this.oleDbDeleteCommand1.CommandText = "DELETE FROM TRDMembers WHERE
(OwnerID = ?) AND (City = ? OR ? IS NULL AND City IS" +

" NULL) AND (Email = ?) AND (FirstName = ?) AND (IsBreeder = ?) AND
(LastName = ?" +

") AND (State = ? OR ? IS NULL AND State IS NULL)";

this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_OwnerID",
System.Data.OleDb.OleDbType.VarWChar, 100,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "OwnerID", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Email",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Email", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_FirstName",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "FirstName", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_IsBreeder",
System.Data.OleDb.OleDbType.Boolean, 2,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "IsBreeder", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_LastName",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "LastName", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State",
System.Data.OleDb.OleDbType.VarWChar, 2,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State1",
System.Data.OleDb.OleDbType.VarWChar, 2,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

//

// oleDbConnection1

//

this.oleDbConnection1.ConnectionString =
@"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data
Source=C:\Inetpub\wwwroot\TRDCommunity\db\thairidgeba_TRD.mdb;Mode=Share
Deny None;Extended Properties="""";Jet OLEDB:System database="""";Jet
OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine
Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt
Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet
OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";

//

// ds

//

this.ds.DataSetName = "NewDataSet";

this.ds.Locale = new System.Globalization.CultureInfo("en-US");

this.Load += new System.EventHandler(this.Page_Load);

((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();

}

#endregion

private void RowUpdated(object sender, OleDbRowUpdatedEventArgs rue)

{

if (rue.Status == UpdateStatus.ErrorsOccurred)

{

rue.Status = UpdateStatus.Continue;

rue.Row.RowError = rue.Errors.Message ;

Trace.Write("Row error occured: " + rue.Errors.Message, "TRDUpdate Web
Service::RowUpdated");

}

else

{

rue.Row.ClearErrors();


}

}

private void oleDbDataAdapter2_RowUpdated(object sender,
System.Data.OleDb.OleDbRowUpdatedEventArgs e)

{


}

private void oleDbConnection1_InfoMessage(object sender,
System.Data.OleDb.OleDbInfoMessageEventArgs e)

{


}

private void Button1_Click(object sender, System.EventArgs e)

{

this.Update();

}

}

}
 
S

Stacey Feldman

Oh..I figured out what was wrong. I need to have the order of the parameters
in the statement the same as the order of the parameter items in the Command
object's ItemArray!

Stacey Feldman said:
Below, is a sample code I have been using to test my application. I have
been tearing my hair out with this. For the code below, I used the
OleDbDataAdapter config that is generated by the VS.NET Adapter Config
wizard.

When Update is called on the adapter, I get a concurrency error. There is NO
ONE else using the database. There have been no changes to the underlying
data. I know something is wrong with the command

This has happened to others and they have posted to newsgroups, but I have
not found any answers there....does anyone know what is going on???

Please help!



Stacey





============================================================================
======



using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Data.OleDb;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using Thairidgebackdog.Applications.TRDCommunity.TRDUpdate;

namespace Thairidgebackdog.Applications.TRDCommunity

{

/// <summary>

/// Summary description for tester.

/// </summary>

public class tester : System.Web.UI.Page

{

protected System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;

protected System.Data.OleDb.OleDbCommand oleDbSelectCommand1;

protected System.Data.OleDb.OleDbCommand oleDbInsertCommand1;

protected System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;

protected System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;

protected System.Data.OleDb.OleDbConnection oleDbConnection1;

protected System.Data.DataSet ds;

protected System.Web.UI.WebControls.Button Button1;


private void Page_Load(object sender, System.EventArgs e)

{


//if(!this.IsPostBack)

{ oleDbConnection1.Open();

oleDbDataAdapter1.SelectCommand.Parameters["OwnerID"].Value =
"2e31638826a94193a4b3b60689e4999f";

oleDbDataAdapter1.SelectCommand.Parameters["OwnerID"].SourceColumn =
"OwnerID";

oleDbDataAdapter1.SelectCommand.Parameters["OwnerID"].SourceVersion =
System.Data.DataRowVersion.Original;



oleDbDataAdapter1.Fill(ds,"TRDMembers");


}



}


public void Update()

{

DataRow tr = ds.Tables["TRDMembers"].Rows[0];

tr.BeginEdit();

tr["Email"] = "(e-mail address removed)";

tr.EndEdit();

oleDbDataAdapter1.RowUpdated += new
OleDbRowUpdatedEventHandler(this.RowUpdated);


DataSet changes = ds.GetChanges();

if (changes != null)

{

//oleDbDataAdapter1.UpdateCommand.Parameters["OwnerID"].Value =
"2e31638826a94193a4b3b60689e4999f";

// oleDbDataAdapter1.UpdateCommand.Parameters["OwnerID"].SourceColumn =
"OwnerID";

//oleDbDataAdapter1.UpdateCommand.Parameters["OwnerID"].SourceVersion =
System.Data.DataRowVersion.Original;

oleDbDataAdapter1.Update(changes,"TRDMembers");


//Don't commit if errors occured

if (!changes.HasErrors)

{

//Commit the txn

//tran.Commit();

//Commit the changes to the dataset

//ds.AcceptChanges();

}

else

{

//Dataset has errors - roll back the transaction

//ds.RejectChanges();

//tran.Rollback();

}


}

// Put user code to initialize the page here

}

#region Web Form Designer generated code

override protected void OnInit(EventArgs e)

{

//

// CODEGEN: This call is required by the ASP.NET Web Form Designer.

//

InitializeComponent();

base.OnInit(e);

}


/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();

this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();

this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();

this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();

this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();

this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();

this.ds = new System.Data.DataSet();

((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();

this.Button1.Click += new System.EventHandler(this.Button1_Click);

//

// oleDbDataAdapter1

//

this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;

this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;

this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;

this.oleDbDataAdapter1.TableMappings.AddRange(new
System.Data.Common.DataTableMapping[] {

new System.Data.Common.DataTableMapping("Table", "TRDMembers", new
System.Data.Common.DataColumnMapping[] {

new System.Data.Common.DataColumnMapping("City", "City"),

new System.Data.Common.DataColumnMapping("Country", "Country"),

new System.Data.Common.DataColumnMapping("Email", "Email"),

new System.Data.Common.DataColumnMapping("FirstName", "FirstName"),

new System.Data.Common.DataColumnMapping("IsBreeder", "IsBreeder"),

new System.Data.Common.DataColumnMapping("LastName", "LastName"),

new System.Data.Common.DataColumnMapping("State", "State")})});

this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;

//

// oleDbSelectCommand1

//

this.oleDbSelectCommand1.CommandText = "SELECT City, Country, Email,
FirstName, IsBreeder, LastName, State, OwnerID FROM " +

"TRDMembers WHERE (OwnerID = ?)";

this.oleDbSelectCommand1.Connection = this.oleDbConnection1;

this.oleDbSelectCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("OwnerID",
System.Data.OleDb.OleDbType.VarWChar, 100, "OwnerID"));

//

// oleDbInsertCommand1

//

this.oleDbInsertCommand1.CommandText = "INSERT INTO TRDMembers(City,
Country, Email, FirstName, IsBreeder, LastName, Stat" +

"e, OwnerID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";

this.oleDbInsertCommand1.Connection = this.oleDbConnection1;

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("City",
System.Data.OleDb.OleDbType.VarWChar, 50, "City"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Country",
System.Data.OleDb.OleDbType.Integer, 0,
System.Data.ParameterDirection.Input, false, ((System.Byte)(10)),
((System.Byte)(0)), "Country", System.Data.DataRowVersion.Current, null));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Email",
System.Data.OleDb.OleDbType.VarWChar, 50, "Email"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("FirstName",
System.Data.OleDb.OleDbType.VarWChar, 50, "FirstName"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("IsBreeder",
System.Data.OleDb.OleDbType.Boolean, 2, "IsBreeder"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("LastName",
System.Data.OleDb.OleDbType.VarWChar, 50, "LastName"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("State",
System.Data.OleDb.OleDbType.VarWChar, 2, "State"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("OwnerID",
System.Data.OleDb.OleDbType.VarWChar, 100, "OwnerID"));

//

// oleDbUpdateCommand1

//

this.oleDbUpdateCommand1.CommandText = @"UPDATE TRDMembers SET City = ?,
Country = ?, Email = ?, FirstName = ?, IsBreeder = ?, LastName = ?, State =
? WHERE (OwnerID = ?) AND (City = ? OR ? IS NULL AND City IS NULL) AND
(Email = ?) AND (FirstName = ?) AND (IsBreeder = ?) AND (LastName = ?) AND
(State = ? OR ? IS NULL AND State IS NULL)";

this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("City",
System.Data.OleDb.OleDbType.VarWChar, 50, "City"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Country",
System.Data.OleDb.OleDbType.Integer, 0,
System.Data.ParameterDirection.Input, false, ((System.Byte)(10)),
((System.Byte)(0)), "Country", System.Data.DataRowVersion.Current, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Email",
System.Data.OleDb.OleDbType.VarWChar, 50, "Email"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("FirstName",
System.Data.OleDb.OleDbType.VarWChar, 50, "FirstName"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("IsBreeder",
System.Data.OleDb.OleDbType.Boolean, 2, "IsBreeder"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("LastName",
System.Data.OleDb.OleDbType.VarWChar, 50, "LastName"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("State",
System.Data.OleDb.OleDbType.VarWChar, 2, "State"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("OwnerID",
System.Data.OleDb.OleDbType.VarWChar, 100, "OwnerID"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_OwnerID",
System.Data.OleDb.OleDbType.VarWChar, 100,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "OwnerID", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Email",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Email", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_FirstName",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "FirstName", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_IsBreeder",
System.Data.OleDb.OleDbType.Boolean, 2,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "IsBreeder", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_LastName",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "LastName", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State",
System.Data.OleDb.OleDbType.VarWChar, 2,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State1",
System.Data.OleDb.OleDbType.VarWChar, 2,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

//

// oleDbDeleteCommand1

//

this.oleDbDeleteCommand1.CommandText = "DELETE FROM TRDMembers WHERE
(OwnerID = ?) AND (City = ? OR ? IS NULL AND City IS" +

" NULL) AND (Email = ?) AND (FirstName = ?) AND (IsBreeder = ?) AND
(LastName = ?" +

") AND (State = ? OR ? IS NULL AND State IS NULL)";

this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_OwnerID",
System.Data.OleDb.OleDbType.VarWChar, 100,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "OwnerID", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Email",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Email", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_FirstName",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "FirstName", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_IsBreeder",
System.Data.OleDb.OleDbType.Boolean, 2,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "IsBreeder", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_LastName",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "LastName", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State",
System.Data.OleDb.OleDbType.VarWChar, 2,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State1",
System.Data.OleDb.OleDbType.VarWChar, 2,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

//

// oleDbConnection1

//

this.oleDbConnection1.ConnectionString =
@"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data
Source=C:\Inetpub\wwwroot\TRDCommunity\db\thairidgeba_TRD.mdb;Mode=Share
Deny None;Extended Properties="""";Jet OLEDB:System database="""";Jet
OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine
Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt
Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet
OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";

//

// ds

//

this.ds.DataSetName = "NewDataSet";

this.ds.Locale = new System.Globalization.CultureInfo("en-US");

this.Load += new System.EventHandler(this.Page_Load);

((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();

}

#endregion

private void RowUpdated(object sender, OleDbRowUpdatedEventArgs rue)

{

if (rue.Status == UpdateStatus.ErrorsOccurred)

{

rue.Status = UpdateStatus.Continue;

rue.Row.RowError = rue.Errors.Message ;

Trace.Write("Row error occured: " + rue.Errors.Message, "TRDUpdate Web
Service::RowUpdated");

}

else

{

rue.Row.ClearErrors();


}

}

private void oleDbDataAdapter2_RowUpdated(object sender,
System.Data.OleDb.OleDbRowUpdatedEventArgs e)

{


}

private void oleDbConnection1_InfoMessage(object sender,
System.Data.OleDb.OleDbInfoMessageEventArgs e)

{


}

private void Button1_Click(object sender, System.EventArgs e)

{

this.Update();

}

}

}
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Another DataGrid Sorting problem 3
sintax error in INSERT INTO statement 2
What are OleDbParameter names with 'Original_' prefix? 5
Insert into Access with C# 1
Concurrency Troubles using Access as Database '?' Appear in SQL 1
DBConcurrencyException when using OleDBTypes DBDate and Double 1
Newbie - Update method not saving with Access database 6
dataset error 4

Top