Hello,

is ado.net a seperate language or does it just represent dot.nets data
capability.

when planning a dataapplication with a lot of data is best to link to a
outside source ie access, sql. Or is best to generate your own sources
using ado.net and xml?

WStoreyII

Thanks Again

ADO.NET is used to talk about the data access classes in .NET. It is not a
separate technology or language - just a section of the .NET framework.

You use ADO.NET to retrieve data from sources such as access, sql server,
etc, so I'm not sure what your second question is asking.

"WStoreyII" <(E-Mail Removed)> wrote in message
news:yBhdc.34435$(E-Mail Removed)...
> Hello,
>
> is ado.net a seperate language or does it just represent dot.nets data
> capability.
>
> when planning a dataapplication with a lot of data is best to link to a
> outside source ie access, sql. Or is best to generate your own sources
> using ado.net and xml?
>
> WStoreyII
>
> Thanks Again
>
>

Marina, i guess that in the second question i am asking what would the best
data source to be ? I am making a project that will basically be a interface
to all of my data
finance accounts dvd ect? I am new to programming and don't know much and
am wondering which would be better

structures?
xml?
Access?

Cant afford sql so thats out anyways

but xml seems logical to me because it can be used on anything even the
above sources if neccasary

WStoreyII


"Marina" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> ADO.NET is used to talk about the data access classes in .NET. It is not
a
> separate technology or language - just a section of the .NET framework.
>
> You use ADO.NET to retrieve data from sources such as access, sql server,
> etc, so I'm not sure what your second question is asking.
>
> "WStoreyII" <(E-Mail Removed)> wrote in message
> news:yBhdc.34435$(E-Mail Removed)...
> > Hello,
> >
> > is ado.net a seperate language or does it just represent dot.nets data
> > capability.
> >
> > when planning a dataapplication with a lot of data is best to link to a
> > outside source ie access, sql. Or is best to generate your own sources
> > using ado.net and xml?
> >
> > WStoreyII
> >
> > Thanks Again
> >
> >
>
>

MSDE (which *is* SQL Server) is free.
So I am not sure why you can't afford it.

MSDE has a 2GB limit for database size.
It also "slows down" if there are more han 5 concurrent processes running.
You could probably support a few hundred users with MSDE simultaneously
since each request is in milli-seconds and most time is spent looking at the
screen.

If you outgrow MSDE then you can upgrade to SQL Server.
--
Joe Fallon



"WStoreyII" <(E-Mail Removed)> wrote in message
news:UFjdc.19823$(E-Mail Removed)...
> Marina, i guess that in the second question i am asking what would the
best
> data source to be ? I am making a project that will basically be a
interface
> to all of my data
> finance accounts dvd ect? I am new to programming and don't know much and
> am wondering which would be better
>
> structures?
> xml?
> Access?
>
> Cant afford sql so thats out anyways
>
> but xml seems logical to me because it can be used on anything even the
> above sources if neccasary
>
> WStoreyII
>
>
> "Marina" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > ADO.NET is used to talk about the data access classes in .NET. It is
not
> a
> > separate technology or language - just a section of the .NET framework.
> >
> > You use ADO.NET to retrieve data from sources such as access, sql
server,
> > etc, so I'm not sure what your second question is asking.
> >
> > "WStoreyII" <(E-Mail Removed)> wrote in message
> > news:yBhdc.34435$(E-Mail Removed)...
> > > Hello,
> > >
> > > is ado.net a seperate language or does it just represent dot.nets data
> > > capability.
> > >
> > > when planning a dataapplication with a lot of data is best to link to
a
> > > outside source ie access, sql. Or is best to generate your own
sources
> > > using ado.net and xml?
> > >
> > > WStoreyII
> > >
> > > Thanks Again
> > >
> > >
> >
> >
>
>

how do you use msde then what is the differences between that and xml??

"Joe Fallon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> MSDE (which *is* SQL Server) is free.
> So I am not sure why you can't afford it.
>
> MSDE has a 2GB limit for database size.
> It also "slows down" if there are more han 5 concurrent processes running.
> You could probably support a few hundred users with MSDE simultaneously
> since each request is in milli-seconds and most time is spent looking at
the
> screen.
>
> If you outgrow MSDE then you can upgrade to SQL Server.
> --
> Joe Fallon
>
>
>
> "WStoreyII" <(E-Mail Removed)> wrote in message
> news:UFjdc.19823$(E-Mail Removed)...
> > Marina, i guess that in the second question i am asking what would the
> best
> > data source to be ? I am making a project that will basically be a
> interface
> > to all of my data
> > finance accounts dvd ect? I am new to programming and don't know much
and
> > am wondering which would be better
> >
> > structures?
> > xml?
> > Access?
> >
> > Cant afford sql so thats out anyways
> >
> > but xml seems logical to me because it can be used on anything even the
> > above sources if neccasary
> >
> > WStoreyII
> >
> >
> > "Marina" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > ADO.NET is used to talk about the data access classes in .NET. It is
> not
> > a
> > > separate technology or language - just a section of the .NET
framework.
> > >
> > > You use ADO.NET to retrieve data from sources such as access, sql
> server,
> > > etc, so I'm not sure what your second question is asking.
> > >
> > > "WStoreyII" <(E-Mail Removed)> wrote in message
> > > news:yBhdc.34435$(E-Mail Removed)...
> > > > Hello,
> > > >
> > > > is ado.net a seperate language or does it just represent dot.nets
data
> > > > capability.
> > > >
> > > > when planning a dataapplication with a lot of data is best to link
to
> a
> > > > outside source ie access, sql. Or is best to generate your own
> sources
> > > > using ado.net and xml?
> > > >
> > > > WStoreyII
> > > >
> > > > Thanks Again
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Hi WS

Ms Access, SQL server, MSDE (a mini SQL server) are Microsoft databases.

SQL server and MSDE function as a service on your network.
MS Access is a file to connect to, however can be used when connected to in
the same way as any other database.

To get and store the information in those databases you can use the classes
as provided in ADO.NET or the classic ADO.

One of the techniques from ADO.NET is to store that data in so-called
Datasets. Those datasets you can process in your programs and that
possessing is often called ADO.NET. However, it is not different from
processing an Array or a Control. The structure of a Dataset is the same as
the structure from an XML file; however, it uses only the "element" tags
because it has the format of SQL compatible databases. XML is much more
extended as a database, by instance complex elements are not in a SQL type
database.

A dataset can be stored in a String by using different dotNet techniques,
the easiest one are the dataset.xmlwrite and dataset.xmlread. With that a
dataset becomes also very simple a dataset on disk in the XML format.
(Readable as a txt file).

I hope this helps?

Cor