when i upload to intenet, it will show this error msg - Operation must use an updateable query. Line 119: dbcomm=New OleDbCommand(sql,dbconn) Line 120: dbread=dbcomm.ExecuteReader() Line 121: dbconn.close() Line 122: dbread.close() At the Internet, got database, table, file and folder! All Got! just the code not unable to run! izit the NT file not set! my web config js write as - < < < < < HOW??? HELP??:wtf: -- modified at 22:58 Monday 13th February, 2006

I using below code to connect to database, but it occur error msg. dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data & _ source=" & server.mappath("er.mdb")) dbconn.Open() Sql= "Update tbData set username = 'yyy'" dbcomm=New OleDbCommand(sql,dbconn) dbread=dbcomm.ExecuteReader() I think the problem is i not set the NT file system??? can somebody help me...:omg:

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:

Ya, my [bldinein] table got primary key, [billing_no] is the primary key!!!:doh:

My database access is using this code : dim dbconn,sql,dbcomm,dbread dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; &_ data source=" & server.mappath("er.mdb")) dbconn.Open() sql="update bldinein set showno = '' Where billing_no = ''" dbcomm=New OleDbCommand(sql,dbconn) dbread=dbcomm.ExecuteReader() dbconn.close() But when I upload the file 2 internet, there will show error msg "Operation must use an updateable query". How 2solve this problem? :^)

document.getElementById("....") is using the javascript, right! then can i know how 2write in VB to get the value from the html input box??? :->

Can u let me know how 2write the aspx code behind??

Thanks 4 help! but its your code is write at c#. where 2 place your code, my code is using :- <%@ Page Language="VB" %> can u write a full set code, let me c??? TQ TQ

Ya, I know using Confirm, but the code is write as :- respnse.write(confirm(example)) how 2 get the true or false value???

my code is using javascipt to declare the alert message, bcoz ASP.Net server-side cannot declare example - msgbox('xxx') alert('xxxx') then how can i capture OK or CANCEL from the messagebox, for example:- confrim('xxxx') or using other method 2 declare it! help??? -- modified at 1:51 Tuesday 7th February, 2006