BeginEdit/EndEdit does not work

[Anil Gupte/iCinema.com]

I have the following code:
Dim strContentInfo As String = "ContentID='" & CUID & "'"

Dim drContentInfo As DataRow() =
GlobalDataSet.Tables("PaidContent").Select(strCont entInfo)

<Some other stuff happens here to set NumPlays>

drContentInfo(0).BeginEdit()

drContentInfo(0).ItemArray(2) = NumPlays

drContentInfo(0).EndEdit()

drContentInfo(0).AcceptChanges()

GlobalDataSet.AcceptChanges()
However the values in the dataset or even the datarow are not changing. No
errors. I stepped through it to see what was happening and I coud not find
any problems. The HasErrors on the row is false, the RowError = "", but the
RowState says "Unchanged". What is wrong here?

TIA,

--
Anil Gupte
www.keeninc.net
www.icinema.com
www.wizo.tv

[Scott M.]

What happens if you skip all the extra code and just try:
drContentInfo(0).ItemArray(2) = NumPlays?

Generally, you don't really need the BeginEdit, EndEdit, AcceptChanges stuff
just to set a value.

-Scott

"Anil Gupte/iCinema.com" <an*******@icinema.comwrote in message
news:Op**************@TK2MSFTNGP03.phx.gbl...

>I have the following code:
Dim strContentInfo As String = "ContentID='" & CUID & "'"

Dim drContentInfo As DataRow() =
GlobalDataSet.Tables("PaidContent").Select(strCont entInfo)

<Some other stuff happens here to set NumPlays>

drContentInfo(0).BeginEdit()

drContentInfo(0).ItemArray(2) = NumPlays

drContentInfo(0).EndEdit()

drContentInfo(0).AcceptChanges()

GlobalDataSet.AcceptChanges()
However the values in the dataset or even the datarow are not changing.
No errors. I stepped through it to see what was happening and I coud not
find any problems. The HasErrors on the row is false, the RowError = "",
but the RowState says "Unchanged". What is wrong here?

TIA,

--
Anil Gupte
www.keeninc.net
www.icinema.com
www.wizo.tv

[=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=]

Anil,

The RowState is unchanged because you are calling AcceptChanges.

AcceptChanges is a very misunderstood method that should almost never be
called.

Kerry Moorman

"Anil Gupte/iCinema.com" wrote:

I have the following code:
Dim strContentInfo As String = "ContentID='" & CUID & "'"

Dim drContentInfo As DataRow() =
GlobalDataSet.Tables("PaidContent").Select(strCont entInfo)

<Some other stuff happens here to set NumPlays>

drContentInfo(0).BeginEdit()

drContentInfo(0).ItemArray(2) = NumPlays

drContentInfo(0).EndEdit()

drContentInfo(0).AcceptChanges()

GlobalDataSet.AcceptChanges()
However the values in the dataset or even the datarow are not changing. No
errors. I stepped through it to see what was happening and I coud not find
any problems. The HasErrors on the row is false, the RowError = "", but the
RowState says "Unchanged". What is wrong here?

TIA,

--
Anil Gupte
www.keeninc.net
www.icinema.com
www.wizo.tv

[Steve Gerrard]

Anil Gupte/iCinema.com wrote:

>
drContentInfo(0).BeginEdit()

drContentInfo(0).ItemArray(2) = NumPlays

drContentInfo(0).EndEdit()

At this point, the rowstate is changed.

>
drContentInfo(0).AcceptChanges()

AcceptChanges means the changes now become the original values, and all rows are
marked as unchanged.

It is typically called after successfully saving the changes to a database, or
after refreshing data from a database.

[Anil Gupte/iCinema.com]

OK, after three hours and lots of Googling (and posting to NewsGroups) I
finally fixed the problem. I changed

drContentInfo(0).ItemArray(2) = NumPlays
to
drContentInfo(0).Item("NumPlays") = NumPlays

and it works! Go figure. I am really curious though why this happened.

On another note, the RowState remains unchanged (I stepped through each
line) before and after the .AcceptChanges() I added
GlobalDataSet.AcceptChanges() thinking I needed to do that to fix the
problems. Anyway, now I have the problem fixed, I will remove the
..AcceptChanges.

Thanx for all the comments.
--
Anil Gupte
www.keeninc.net
www.icinema.com
www.wizo.tv
"Anil Gupte/iCinema.com" <an*******@icinema.comwrote in message
news:Op**************@TK2MSFTNGP03.phx.gbl...

>I have the following code:
Dim strContentInfo As String = "ContentID='" & CUID & "'"

Dim drContentInfo As DataRow() =
GlobalDataSet.Tables("PaidContent").Select(strCont entInfo)

<Some other stuff happens here to set NumPlays>

drContentInfo(0).BeginEdit()

drContentInfo(0).ItemArray(2) = NumPlays

drContentInfo(0).EndEdit()

drContentInfo(0).AcceptChanges()

GlobalDataSet.AcceptChanges()
However the values in the dataset or even the datarow are not changing.
No errors. I stepped through it to see what was happening and I coud not
find any problems. The HasErrors on the row is false, the RowError = "",
but the RowState says "Unchanged". What is wrong here?

TIA,

--
Anil Gupte
www.keeninc.net
www.icinema.com
www.wizo.tv

[Cor Ligthert[MVP]]

See my answer in one of the other newsgroup you multiposted too.

Cor

"Anil Gupte/iCinema.com" <an*******@icinema.comschreef in bericht
news:Op**************@TK2MSFTNGP03.phx.gbl...

>I have the following code:
Dim strContentInfo As String = "ContentID='" & CUID & "'"

Dim drContentInfo As DataRow() =
GlobalDataSet.Tables("PaidContent").Select(strCont entInfo)

<Some other stuff happens here to set NumPlays>

drContentInfo(0).BeginEdit()

drContentInfo(0).ItemArray(2) = NumPlays

drContentInfo(0).EndEdit()

drContentInfo(0).AcceptChanges()

GlobalDataSet.AcceptChanges()
However the values in the dataset or even the datarow are not changing.
No errors. I stepped through it to see what was happening and I coud not
find any problems. The HasErrors on the row is false, the RowError = "",
but the RowState says "Unchanged". What is wrong here?

TIA,

--
Anil Gupte
www.keeninc.net
www.icinema.com
www.wizo.tv