Re: DataBase

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


Date: Fri, 3 Dec 2004 14:33:40 -0500

Actualy I just took a look at one of the projects I played around with in VB
a while back and I did in fact use a DataSet. Take a look at the DataSet
methods for:

ds.ReadXmlSchema("c:\attendees_Schema.xml")

ds.ReadXml("c:\Attendees_Data.xml")

There are also equivelent Write methods as well.

-- 
Andrew J. Kelly  SQL MVP
"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message 
news:eW0F3cT2EHA.1076@TK2MSFTNGP09.phx.gbl...
> 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 ... > And do you know something a databse that comes directly with windows. ... >> Andrew J. Kelly SQL MVP ... >>> database, but I need it not to use any SQl server. ...
    (microsoft.public.dotnet.languages.csharp)