Connect Access MDB

[shahid]

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...

[hellswraith]

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?

[shahid]

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.....