Newie needs data access

[ralf]

I was not sure which group deals with this is I apologize.
I need to connect to an MS Access DB and add. delete & update from an ASPX
page (using vb.net for code behind if needed)

Are there any sites that show code snippets ?
Both DSN & DSNless connections please

I can find them for ASP but none for aspx
Looks like aspx uses ado.net instead of ado & code is probably different if
only slightly (I don't know)

Thanks a lot in advance.

 

[Dmitriy Lapshin [C# / .NET MVP]]

Hi Ralf,

ASPX (that is, ASP .NET) pages indeed use ADO .NET. ADO .NET, in turn, can
talk to the Microsoft Jet OLEDB provider through its Managed OLEDB Provider
found in the System.Data.OleDB namespace. As far as I remember DSNs are
related to ODBC and ODBC is not a native way of working with MS Access
databases. So, you will be using OLEDB-compatible connection strings as if
you were working with the Jet OLEDB provider.

You can find information and examples on working with ADO .NET in the
"Accessing Data with ADO.NET" on the MSDN Library
(http://msdn.microsoft.com/library).

 

[ralf]

Thanks for posting but unfortunately I have no time to reinvent the wheel by
studying ado.net from scratch
I posted because someone may already have written the code that I can reuse
and that is what I am
looking for .

Hi Ralf,

ASPX (that is, ASP .NET) pages indeed use ADO .NET. ADO .NET, in turn, can
talk to the Microsoft Jet OLEDB provider through its Managed OLEDB Provider
found in the System.Data.OleDB namespace. As far as I remember DSNs are
related to ODBC and ODBC is not a native way of working with MS Access
databases. So, you will be using OLEDB-compatible connection strings as if
you were working with the Jet OLEDB provider.

You can find information and examples on working with ADO .NET in the
"Accessing Data with ADO.NET" on the MSDN Library
(http://msdn.microsoft.com/library).

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

I was not sure which group deals with this is I apologize.
I need to connect to an MS Access DB and add. delete & update from an ASPX
page (using vb.net for code behind if needed)

Are there any sites that show code snippets ?
Both DSN & DSNless connections please

I can find them for ASP but none for aspx
Looks like aspx uses ado.net instead of ado & code is probably different if
only slightly (I don't know)

Thanks a lot in advance.