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.

Just as you have your SQL SELECT statement, you must also have an SQL UPDATE statement.
Your OleDbDataAdapter has a SelectCommand set through the OleDbDataAdapter(strSQL, cnx) constructor; however you don't have a corresponding UpdateCommand assigned.

You'll need something like:

sda.UpdateCommand = new OleDbCommand("UPDATE something SET something = @Something WHERE something = something", conn)

More info on the OleDbDataAdapter.UpdateCommand Property:
http://msdn.microsoft.com/library/de...mmandtopic.asp

- A.Kahtava

Thanks very much. I have to learn and play with it a little more.
But I was looking for the way to do similar like in ASP

In ASP we could do
  rst("fieldname")=value
  rst.Movenext

instead of writing sql statement, which can be very long if a lot of fields should be updated.

So I thought about something similar in asp.net.
Thanks a lot.

ASP to ASP.NET is a fairly steep learning curve, but the benifits are huge.
It's best to approach ASP.NET & ADO.NET as a whole new concept with a couple syntactical similarities to ASP.

- A.Kahtava