how to update a datatable to access

odelya

Member
Joined
Mar 13, 2005
Messages
10
Programming Experience
Beginner
hi!
i have this datatable:
VB.NET:
adpt = New OleDbDataAdapter("select * from design where id=2", cnn)
 
adpt.fill(header)
header.Rows(0).Item("font") = lbl.Font
 
header.Rows(0).Item("fore_color") = lbl.ForeColor
 
header.Rows(0).Item("font_size") = lbl.Font.Size
 
header.Rows(0).Item("italic") = lbl.Font.Italic
 
header.Rows(0).Item("bold") = lbl.Font.Bold
 
when i want to update the datatable to access, i write:
adpt.Update(dt)
all the lines are running, except for the last one which says:
Update requires a valid UpdateCommand when passed DataRow collection with modified rows.
what can i do?
 
Last edited by a moderator:
Top Bottom