DataAdapter Update() Help

[Steve B.]

Does anyone know why the DA Update() would throw an exception?

I moved the database but I updated the Conn and the DA, currently
(trying)removin g/replacing DS. Is there a another direction I should be
looking in? Does it matter if I move columns in the grid (everything is a
string anyways)? Does the DS need to be udated from the DT?
***************
int rowNo = dg.CurrentRowIn dex;

dt = dt .Rows[rowNo].BeginEdit();
dt = dt .Rows[rowNo][columnName] = strgCellFill;
dt = dt .Rows[rowNo].EndEdit();

string s = dt.Rows[rowNo][columnName]; // s = strgCellFill

DataRow dr = dt.Rows[rowNo];
string s1 = dr.RowState.ToS tring(); // s1 = "Modified"

DS dataSetChanges = getDataSetChang es();

if (dataSetChanges .HasChanges())
{
this.Conn.Open( );
this.da.Update( ds); //throws an exception
this.Conn.Close ();
}

[LEBRUN Thomas]

What is the error message that comes with the exception ?

-------------------
LEBRUN Thomas
http://morpheus.developpez.com
http://blog.developpez.com/index.php?blog=9
"Steve B." wrote:

Does anyone know why the DA Update() would throw an exception?

I moved the database but I updated the Conn and the DA, currently
(trying)removin g/replacing DS. Is there a another direction I should be
looking in? Does it matter if I move columns in the grid (everything is a
string anyways)? Does the DS need to be udated from the DT?
***************
int rowNo = dg.CurrentRowIn dex;

dt = dt .Rows[rowNo].BeginEdit();
dt = dt .Rows[rowNo][columnName] = strgCellFill;
dt = dt .Rows[rowNo].EndEdit();

string s = dt.Rows[rowNo][columnName]; // s = strgCellFill

DataRow dr = dt.Rows[rowNo];
string s1 = dr.RowState.ToS tring(); // s1 = "Modified"

DS dataSetChanges = getDataSetChang es();

if (dataSetChanges .HasChanges())
{
this.Conn.Open( );
this.da.Update( ds); //throws an exception
this.Conn.Close ();
}

[Steve B.]

It's a System.Data.Ole Db.OleDbExcepti on.

Looks like the database. Wouldn't the Open() fail if it was a problem with
the dB?

Should I recreate the Conn, DA and DS

Steve

"Steve B." wrote:

Does anyone know why the DA Update() would throw an exception?

I moved the database but I updated the Conn and the DA, currently
(trying)removin g/replacing DS. Is there a another direction I should be
looking in? Does it matter if I move columns in the grid (everything is a
string anyways)? Does the DS need to be udated from the DT?
***************
int rowNo = dg.CurrentRowIn dex;

dt = dt .Rows[rowNo].BeginEdit();
dt = dt .Rows[rowNo][columnName] = strgCellFill;
dt = dt .Rows[rowNo].EndEdit();

string s = dt.Rows[rowNo][columnName]; // s = strgCellFill

DataRow dr = dt.Rows[rowNo];
string s1 = dr.RowState.ToS tring(); // s1 = "Modified"

DS dataSetChanges = getDataSetChang es();

if (dataSetChanges .HasChanges())
{
this.Conn.Open( );
this.da.Update( ds); //throws an exception
this.Conn.Close ();
}

[Steve B.]

Could it have to do with folder permissions? the properties -security tab
Allow column is checked?? NFTS?? ASPNET permissions?

Steve

"Steve B." wrote:

It's a System.Data.Ole Db.OleDbExcepti on.

Looks like the database. Wouldn't the Open() fail if it was a problem with
the dB?

Should I recreate the Conn, DA and DS

Steve

"Steve B." wrote:

Does anyone know why the DA Update() would throw an exception?

I moved the database but I updated the Conn and the DA, currently
(trying)removin g/replacing DS. Is there a another direction I should be
looking in? Does it matter if I move columns in the grid (everything is a
string anyways)? Does the DS need to be udated from the DT?
***************
int rowNo = dg.CurrentRowIn dex;

dt = dt .Rows[rowNo].BeginEdit();
dt = dt .Rows[rowNo][columnName] = strgCellFill;
dt = dt .Rows[rowNo].EndEdit();

string s = dt.Rows[rowNo][columnName]; // s = strgCellFill

DataRow dr = dt.Rows[rowNo];
string s1 = dr.RowState.ToS tring(); // s1 = "Modified"

DS dataSetChanges = getDataSetChang es();

if (dataSetChanges .HasChanges())
{
this.Conn.Open( );
this.da.Update( ds); //throws an exception
this.Conn.Close ();
}

[LEBRUN Thomas]

> It's a System.Data.Ole Db.OleDbExcepti on.

Ok, but you need to catch nd display the complete error of th exception ;)

Bye

-------------------
LEBRUN Thomas
http://morpheus.developpez.com
http://blog.developpez.com/index.php?blog=9
"Steve B." wrote:

It's a System.Data.Ole Db.OleDbExcepti on.

Looks like the database. Wouldn't the Open() fail if it was a problem with
the dB?

Should I recreate the Conn, DA and DS

Steve

"Steve B." wrote:

Does anyone know why the DA Update() would throw an exception?

I moved the database but I updated the Conn and the DA, currently
(trying)removin g/replacing DS. Is there a another direction I should be
looking in? Does it matter if I move columns in the grid (everything is a
string anyways)? Does the DS need to be udated from the DT?
***************
int rowNo = dg.CurrentRowIn dex;

dt = dt .Rows[rowNo].BeginEdit();
dt = dt .Rows[rowNo][columnName] = strgCellFill;
dt = dt .Rows[rowNo].EndEdit();

string s = dt.Rows[rowNo][columnName]; // s = strgCellFill

DataRow dr = dt.Rows[rowNo];
string s1 = dr.RowState.ToS tring(); // s1 = "Modified"

DS dataSetChanges = getDataSetChang es();

if (dataSetChanges .HasChanges())
{
this.Conn.Open( );
this.da.Update( ds); //throws an exception
this.Conn.Close ();
}

[Steve B.]

I'm studing this don't know what to do yet, creates duplicate key??
Steve

Message1 ---
The changes you requested to the table were not successful because they
would create duplicate values in the index, primary key, or relationship.
Change the data in the field or fields that contain duplicate data, remove
the index, or redefine the index to permit duplicate entries and try again.

String Message ---
System.Data.Ole Db.OleDbExcepti on: The changes you requested to the table
were not successful because they would create duplicate values in the index,
primary key, or relationship. Change the data in the field or fields that
contain duplicate data, remove the index, or redefine the index to permit
duplicate entries and try again.
at System.Data.Com mon.DbDataAdapt er.Update(DataR ow[] dataRows,
DataTableMappin g tableMapping)
at System.Data.Com mon.DbDataAdapt er.Update(DataS et dataSet, String
srcTable)
at businessInforma tion.ConfigMgmt Log.UpdateDataB ase() in
c:\businessinfo rmationsoftware \businessinform ation\configmgm tlog.cs:line 2028

HelpLink ---
Source ---
Microsoft JET Database Engine

StackTrace ---
at System.Data.Com mon.DbDataAdapt er.Update(DataR ow[] dataRows,
DataTableMappin g tableMapping)
at System.Data.Com mon.DbDataAdapt er.Update(DataS et dataSet, String
srcTable)
at businessInforma tion.ConfigMgmt Log.UpdateDataB ase() in
c:\businessinfo rmationsoftware \businessinform ation\configmgm tlog.cs:line 2028

TargetSite ---
Int32 Update(System.D ata.DataRow[], System.Data.Com mon.DataTableMa pping)
Inner Exception ---

The program '[1992] businessInforma tion.exe' has exited with code 0 (0x0).

"LEBRUN Thomas" wrote:

It's a System.Data.Ole Db.OleDbExcepti on.

Ok, but you need to catch nd display the complete error of th exception ;)

Bye

-------------------
LEBRUN Thomas
http://morpheus.developpez.com
http://blog.developpez.com/index.php?blog=9
"Steve B." wrote:

It's a System.Data.Ole Db.OleDbExcepti on.

Looks like the database. Wouldn't the Open() fail if it was a problem with
the dB?

Should I recreate the Conn, DA and DS

Steve

"Steve B." wrote:

Does anyone know why the DA Update() would throw an exception?

I moved the database but I updated the Conn and the DA, currently
(trying)removin g/replacing DS. Is there a another direction I should be
looking in? Does it matter if I move columns in the grid (everything is a
string anyways)? Does the DS need to be udated from the DT?
***************
int rowNo = dg.CurrentRowIn dex;

dt = dt .Rows[rowNo].BeginEdit();
dt = dt .Rows[rowNo][columnName] = strgCellFill;
dt = dt .Rows[rowNo].EndEdit();

string s = dt.Rows[rowNo][columnName]; // s = strgCellFill

DataRow dr = dt.Rows[rowNo];
string s1 = dr.RowState.ToS tring(); // s1 = "Modified"

DS dataSetChanges = getDataSetChang es();

if (dataSetChanges .HasChanges())
{
this.Conn.Open( );
this.da.Update( ds); //throws an exception
this.Conn.Close ();
}

[Jeff Louie]

Steve... It sounds like your update would result in a condition not
allowed by
the database such as a row with a duplicate primary key.

Regards,
Jeff

System.Data.Ol eDb.OleDbExcept ion: The changes you requested to the

table were not successful because they would create duplicate values in
the
index, primary key, or relationship.<

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Steve B.]

Thanks. I use a DG and bound CB/TB adjacent to the DG to update the
DG/DS/DB. Right now, for testing purposes, instead of updating all 10 fields
of the DG/DS/DB I'm just updating one field for now and update() no longer
crashes, but that presents another problem:

That one test field (worst case) is a CB and making CB selection
(CB.selectedind ex > 0) is'nt saved to the DB even though the CB selection is
collected properly and sent to updated(). If I manually type an entry at
CB.selectedinde x = 0 the selection is saved to DB but then the field doesn't
update if I change the DG pointer (i.e. keeps the typed valve). I can use
CB.selectedinde x = -1, then fill() again, etc, but not sure if that's the
direction. Cause for a new ADO thread

"Jeff Louie" wrote:

Steve... It sounds like your update would result in a condition not
allowed by
the database such as a row with a duplicate primary key.

Regards,
Jeff

System.Data.Ol eDb.OleDbExcept ion: The changes you requested to the

table were not successful because they would create duplicate values in
the
index, primary key, or relationship.<

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!