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

Re: Newie needs data access

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

"ralf" <--__0ralfr@yahoo. com> wrote in message
news:bluefh$gis ue$1@ID-158805.news.uni-berlin.de...[color=blue]
> 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[/color]
if[color=blue]
> only slightly (I don't know)
>
> Thanks a lot in advance.
>
>[/color]

[ralf]

Re: Newie needs data access


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 .


"Dmitriy Lapshin [C# / .NET MVP]" <x-code@no-spam-please.hotpop.c om> wrote
in message news:etZaLeNjDH A.4048@TK2MSFTN GP11.phx.gbl...[color=blue]
> 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[/color]
Provider[color=blue]
> found in the System.Data.Ole DB 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
>
> "ralf" <--__0ralfr@yahoo. com> wrote in message
> news:bluefh$gis ue$1@ID-158805.news.uni-berlin.de...[color=green]
> > 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[/color][/color]
ASPX[color=blue][color=green]
> > 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[/color]
> if[color=green]
> > only slightly (I don't know)
> >
> > Thanks a lot in advance.
> >
> >[/color]
>[/color]