473,405 Members | 2,262 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

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 1717
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: cooldv | last post by:
i am running a website on Windows 2000 server with ASP 3 webpages and Access 2000 database. (with a hosting company) traffic is slow at this time but expect to grow. lately i have been reading...
0
by: sedefo | last post by:
I ran into this Microsoft Patterns & Practices Enterprise Library while i was researching how i can write a database independent data access layer. In my company we already use Data Access...
12
by: Manolis | last post by:
Hi, I was wondering if there is any way to make two objects of the same class to be able to access each other's private data, like this: class A { public: void access( const A& a )...
20
by: Olav.NET | last post by:
I am a .NET/C++ developer who is supposed to do some work with Access. I do not know much about it except for the DB part. Questions: *1* I am looking for INTENSIVE books to get quickly up to...
37
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why...
9
by: JT | last post by:
Here is the overall structure I will be referring to: End-program ProvideWorkFlow.dll Forms and methods that properly manipulate calls to methods in AccessUtils AccessUtils (a web service)...
14
by: ApexData | last post by:
I am considering building some distributable commercial applications. For about a year now, I have been using Access2000. This was my first venture into object oriented database development. ...
0
by: Tony Hine | last post by:
Problem for Excel Developers One of the problems facing Excel developers moving into MS Access is actually the apparent similarity between MS Access tables and Excel spreadsheets. MS Access is...
7
by: Andy B | last post by:
I have a class I am creating for data access. I need to access controls from inside the class that are on a particular page. How do I do this? or is creating an instance of the page class and using...
2
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.