469,933 Members | 2,534 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,933 developers. It's quick & easy.

ASP.Net/ADO.Net/VB.Net/Access - need example

Where can I find a good explination and example of using VB.Net/ASP.net to
browse an MS Access database using ADO.Net?

Thanks in advance,

John
Nov 18 '05 #1
2 1612
You can start with the Quick Starts:
http://samples.gotdotnet.com/quickstart/howto/

(also on your PC - install samples)

To move from SQL Serve to Access:

1. Change from Sql{Object} to OleDb{Object}

SqlConnection becomes OleDbConnection, for example

2. Alter the connection string to use Jet
3. Run the app

While a bit older, you can find my sample code (a couple in Access) from the
wiley extras site:
http://www.wiley.com/extras/ado_net_xml_asp_net/

Check out the ADO.NET chapters, esp. Chapter 15.

NOTE: Examples in VB.NET

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************** ********************
Think Outside the Box!
************************************************** ********************
"John Howard" <jo*********@dcf.state.fl.us> wrote in message
news:40********@news.hcs.net...
Where can I find a good explination and example of using VB.Net/ASP.net to
browse an MS Access database using ADO.Net?

Thanks in advance,

John

Nov 18 '05 #2
www.dedicationsolutions.co.uk - .net articles has a number of
comparisons wih ASP.NET/VB.NET and ACCESS
"Cowboy \(Gregory A. Beamer\)" <No************@comcast.netNoSpamM> wrote in message news:<#U**************@TK2MSFTNGP12.phx.gbl>...
You can start with the Quick Starts:
http://samples.gotdotnet.com/quickstart/howto/

(also on your PC - install samples)

To move from SQL Serve to Access:

1. Change from Sql{Object} to OleDb{Object}

SqlConnection becomes OleDbConnection, for example

2. Alter the connection string to use Jet
3. Run the app

While a bit older, you can find my sample code (a couple in Access) from the
wiley extras site:
http://www.wiley.com/extras/ado_net_xml_asp_net/

Check out the ADO.NET chapters, esp. Chapter 15.

NOTE: Examples in VB.NET

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************** ********************
Think Outside the Box!
************************************************** ********************
"John Howard" <jo*********@dcf.state.fl.us> wrote in message
news:40********@news.hcs.net...
Where can I find a good explination and example of using VB.Net/ASP.net to
browse an MS Access database using ADO.Net?

Thanks in advance,

John

Nov 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

37 posts views Thread by jasmith | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.