Re: DataBase

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 12/03/04 

Date: Fri, 3 Dec 2004 07:54:17 -0500

It's been a while since I did that but I don't believe you even need a
dataset. I think you can just create a datatable with the columns the way
you want. Then if you populate it with some rows you can save the data as
an XML document (I will look up the method when I get back) on your hard
drive. And later on you can import it back into the datatable. Once it is
in the datatable you can do anything you normally can against it such as
selects, filters etc. It does not matter where the data came from, the
databale behaves pretty much the same. Sorry I don't know anything about
dbase being supported with windows other than there are odbc and possibly
oledb drivers for it now, 

-- 
Andrew J. Kelly  SQL MVP
<John.Arthur@gmail.com> wrote in message 
news:1101980560.308484.263900@f14g2000cwb.googlegroups.com...
>
> I am preaty new to ADO.NET, so let me see if I get it right.
> So if I have some kind of a DataSet I will be able to save it in a
> XML.Next time I start the aplication I will be able to load it in the
> DataSet, so whe whole data will be in the memory.
> But how I will run a select query against this data set?
>
> And do you know something a databse that comes directly with windows. I
> heard something that dbase in the newest version of windows is fully
> suported.
>
> Thankes.
>
> Andrew J. Kelly wrote:
>> You can use XML to store the data pretty easily.  If you build the
> tables
>> with ADO.net you can import or export the data to XML.  For a small
>> application without a real db I think it is better than a flat file.
>>
>> --
>> Andrew J. Kelly  SQL MVP
>>
>>
>> "John Arthur" <John.Arthur@gmail.com> wrote in message
>> news:a88731b6.0412010819.6f4c1567@posting.google.com...
>> > Hi,
>> >
>> > I need to create a small application that uses a file to write and
>> > store some data and then uses this data. What I actually need to
> know
>> > is it posible to create this as a database and create tables in it,
>> > and then read info from this tables with "select" - some kind of a
>> > database, but I need it not to use any SQl server. Just a file to
>> > write in. May be some kind of a .dat file.  I heard the Windows has
>> > samething like that build in. So if I uses C# may be I will be able
> to
>> > use it?
>> > Can someone help me with that.
>> >
>> > Thankes.
>

Relevant Pages

  • Re: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
    (microsoft.public.sqlserver.clients)
  • Re: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
    (microsoft.public.sqlserver.clients)
  • Re: Fill Factor
    ... Well the only way it would go back to 90 is if someone or something is reindexing with a different fill factor. ... Andrew J. Kelly SQL MVP ... > database, i deployed a database to a client and sit the Fill Factor for ...
    (microsoft.public.sqlserver.setup)
  • Re: different environment fails to fill a dataset
    ... Are you sure that the login on the Test system has the database Planit as ... Andrew J. Kelly SQL MVP ... on the test workstation but not my development station. ...
    (microsoft.public.sqlserver.clients)
  • Re: DataBase
    ... Andrew J. Kelly SQL MVP "Andrew J. Kelly" wrote in message ... Sorry I don't know anything about> dbase being supported with windows other than there are odbc and possibly> oledb drivers for it now, ... What I actually need to>> know>>>> is it posible to create this as a database and create tables in it, ...
    (microsoft.public.dotnet.languages.csharp)
Loading