Can you please help me.
Here is my code, it's not giving any error but it does not update the field in the database.

Dim strCnx As String = AccessCnx()
Dim strSQL As String = "SELECT * FROM Schedule"
Dim cnx As OleDbConnection = New OleDbConnection(strCnx)
cnx.Open()

Dim ds As Dataset = New DataSet
Dim sda as OleDbDataAdapter
sda= New OleDbDataAdapter(strSQL, cnx)
sda.Fill(ds, "Schedule")
Dim datarow1 As DataRow
Dim scb as OledbCommandBuilder = New OleDbCommandBuilder(sda)
sda.UpdateCommand = scb.GetUpdateCommand()

 For each datarow1 in ds.Tables("Schedule").Rows
  LL.Text=LL.Text & "<br>--" & datarow1("mo_ye") ' this line works OK
    datarow1.BeginEdit()
     datarow1("mo_ye")="33333" '??this line does not update the value
    datarow1.EndEdit()
  Next

 ds.AcceptChanges()
 sda.Update(ds, "Schedule")
 cnx.Close

Many thanks in advance.

use try, catch. i think this will catch some exception.

vamsi

if you open the "Schedule" table,
what value is shown for "mo_ye"?

what I wanted to ask in the prior reply was,
you said: not updating the field in the database.

does the DataSet ds have the correct updates ?
because if ds is not correct then neither will your database.
bind and display ds to see what is in it.

could you explain this line to me ?
LL.Text=LL.Text & "<br>--" & datarow1("mo_ye")
I was wondering how the "mo_ye" works, does it identify a specific row?

Iwebzem, you have asked for help but you have not replied.
if you have solved your problem please let us know.
share your solution so other can benefit.

previously, i asked you to explain how this line "works" in your code.
LL.Text=LL.Text & "<br>--" & datarow1("mo_ye") ' this line works OK

you don't specify what is meant by "works"
i'll assume you mean the rows are identified in the string builder.

had you replied, next i would have asked you about "this line".
datarow1("mo_ye")="33333" '??this line does not update the value

i'll assume you mean the values in the DataRow.
this should work. however, i think all the values in your column will
be "33333".
that is, not just a value but all values.

is that what you mean by ".....not update the value" ?
if you want only a specific row to have "33333" you would need to specify an Index for that particular row.

lastly, if you mean the value or values in the DataSource are not
being updated, i would try removing the following line from your code.

ds.AcceptChanges()

hope this is of some help to you.
please respond when you ask for help!
many want to help but we don't want to waste time doing research, especially if you already got a solution. share it.