how i connect Ms Access DB thru ASP.NET(ADO.NET)
.
also when i click a submit button it's go another page...
how can i do that...
Printable View
how i connect Ms Access DB thru ASP.NET(ADO.NET)
.
also when i click a submit button it's go another page...
how can i do that...
About the submit button, use Response.Redirect("MyPage.aspx") in your code.
Connecting to a Access DB is the same as it is for regular windows apps. What are you having problems with?
thanks for replay...
in ASP i connect the db like this:
dim con
dim rs
dim constr
constr = "Provider=Microsoft.JET.OLEDB.4.0; Data source=E:\mydb.mdb"
set con = server.createObject("ADODB.Connection")
set rs = server.CreateObject("ADODB.Recordset")
con.open constr
rs.open "select * from mytable",con
can u plz tell me how i wrote it in ASP.NET.....