How 2 write the update, delete and insert code??
ASP.NET
1
Posts
1
Posters
0
Views
1
Watching
-
I using this code to link the database acces: dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & server.mappath("er.mdb")) dbconn.Open() sql="select * from tbData where user_name = 'xxx'" dbcomm=New OleDbCommand(sql,dbconn) dbread=dbcomm.ExecuteReader() dbconn.close() dbread.close() but if i want 2 use this code to update, delete or insert, How 2 write it?? if i js change sql = "Update tbData set user_name = 'yyy'" if will occur error at internet! must change this code:- dbread=dbcomm.ExecuteReader() how 2write it? HELP~~~:confused: