Click here to Skip to main content
Click here to Skip to main content
Go to top

Using .xml files to replace small databases

, 2 Sep 2003
Rate this:
Please Sign up or sign in to vote.
Let an XML file become your local small database.

Sample Image

Introduction

Many software and projects have many files to save data, like .ini, .cfg, .config... And they use any small database hourly, like .mdb. Now, using XML files can replace these files to save any data, under the .NET framework. There are 4 steps that let us complete this mission :p.

Step 1: Building an XML file.

The XML file's formatting must be familiar to you. Like this:

xmlfile

If you open this XML file in VS.NET, you can see button "Data" in the IDE's left bottom. Click the button, you can see some tables from this XML file. Like this:

Sample screenshot

Step 2: Using a DataSet to read XML file.

Create a WinForm project. Add an OpenFileDialog into the main form. We will use it to open the XML file. Like this:

if(openFileDialog1.ShowDialog()==DialogResult.OK) 
{ 
  DataSet ds=new DataSet(); 
  ds.read(openFileDialog1.FileName); 
}

Step 3: Control the DataSet.

In a DataSet instance, we can do some operations like select, add, delete, and update... This is a sample method to search some data:

public DataRow[] searchForm(string tables,string expression) 
{ 
  //ds is a DataSet instance. 
  DataTable dt=ds.Tables[tables]; 
  DataRow[] drs=dt.Select(expression); 
  return drs; 
}

And you can add other methods easily. Like these methods:

//delete some rows from a table.
public bool deleteRows(string tables,string expression)
{
  bool result=false;
  DataTable dt=ds.Tables[tables];
  DataRow[] drs=dt.Select(expression);
  if(drs.Length>0)
  {
    for(int i=0;i<drs.Length;i++) <DRS[].LENGTH;I++)<>drs[i].Delete();
    ds.WriteXml(fileName);
    result=true;
  }
  else
  {
    result=false;
  }
  return result;
}

Step 4: Using DataSet to save data.

One statement can finish the work. Like this:

//fileName is a xml file's full name. 
if(fileName!="") 
ds.WriteXml(fileName);

Now see, the XML file can save data and we can use DataSet to operate on the data Smile | :) .

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

biztig
Web Developer
China China
Sorry,my english is very poor.My name is ShangYuan Wang,and I am working in China GuangXi nanning city,a technology company named biztig.So
my nickname is biztig,and I have an other nickname that is jam_snake. I learned pascal in GuangXi University first at 5 years ago,but my favorite language is C# now.
The image is a famous star in china,and I am her fans.

Comments and Discussions

 
Generalhello Pinmembersamiong727-Jan-09 2:29 
GeneralFor Yantarian Pinmemberavodavtyan23-Oct-07 19:46 
GeneralInitial conditions PinmemberSPIRANCA1-Dec-06 3:40 
Generalcountrymen MM Pinmembervcsharp16-Feb-04 15:25 
GeneralGood ideas must leave something to your own imagination ... Pinmemberintressant@solhem.se25-Sep-03 8:22 
GeneralComment PinsussAnonymously10-Sep-03 16:09 
GeneralRe: Comment Pinmemberjam_snake10-Sep-03 16:49 
GeneralRe: Comment PinsussAnonymously12-Sep-03 15:32 
GeneralRe: Comment PinmemberAzel Low3-Oct-03 2:40 
GeneralRe: Comment Pinsussyantarian11-Nov-03 3:31 
GeneralRe: Comment Pinmemberavodavtyan23-Oct-07 3:33 
GeneralRe: Comment Pinmembereyoung7029-Aug-04 18:52 
GeneralThe other methods Pinmemberjam_snake10-Sep-03 15:32 
GeneralRe: The other methods Pinsussyantarian11-Nov-03 3:35 
GeneralRe: The other methods Pinmemberavodavtyan23-Oct-07 4:01 
GeneralSome more Pinmemberlee_connell10-Sep-03 14:40 
Questionxml as database -max size? Pinmemberdeodatus10-Sep-03 14:25 
AnswerRe: xml as database -max size? Pinmembersaturn_one2-Dec-04 10:44 
AnswerRe: xml as database -max size? PinmemberThe Man from U.N.C.L.E.25-Jun-07 11:34 
GeneralNot enough Pinmemberdog_spawn4-Sep-03 13:08 
GeneralRe: Not enough Pinmemberlee_connell10-Sep-03 14:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140926.1 | Last Updated 3 Sep 2003
Article Copyright 2003 by biztig
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid