hi, i am a beginner, do anyone how to store data into XML database using MS Visual C#.NET ??? example of my XML:

<Enrolment>
       <Name></Name>
       <Gender></Gender>
</Enrolment>

in my web interface, i got a button called "save", a textbox called "txtName", & a dropdownlist/combo box called "cboGender". so, after i enter (data) in all fields that i mentioned above(txtName, cboGender), then click the "save" button, it will store/save all the data that i enter into the XML database. in this program, it can't allow to use SQL connnection. i hope any expert can help me on this. below is my c# code:

private void cmdSave_Click(object sender, System.EventArgs e)
{
   DataSet ds = new DataSet();
   string filepath = @"C:\Documents and Settings\All
                     Users\Documents\Database.xml";
   FileStream findata = new FileStream
                    (filepath,FileMode.OpenOrCreate,FileAccess.Write,
                     FileShare.ReadWrite);
   ds.Tables["Enrolment"].Columns["FirstName"] = txtfname.Text;
   ds.WriteXml(findata);
   findata.Close();
}

P/s: i also dunno how to get the dropdownlist/combo box data & save it into XML database, because textbox property is .text, but combo box there are no .text.

i will appreciate if someone can help me....thanks a lot...

regards,


ck.

__________________
ck.

You can use SelectedValue or SelectedItem.Text or SelectedItem.Value of dropdownlist i think this will help you.

Generally you could create a XML Schema of your XML database/dataset:
You could either create it by adding a new XML Schema (*.xsd) item to you project from the VS and create your database definition by the drag-n-frop methos or create a DataSet object which to write down its own schema for you:
DataSet ds = new DataSet();
            DataTable dt = new DataTable("TableName");
            dt.Columns.Add(new DataColumn("name"));
//in the same manner add the other columns you have
            ds.Tables.Add(dt);//add the table to the dataset
            ds.WriteXmlSchema(@"schema path");//make the dataset write the schema for you - n.b.: uses full path

when you want to load the schema to another dataset just do:
ds.ReadSchema(@"schema path");
//and you have all your tables loaded

From this point on you can fill the data:
DataRow dr = ds.Tables[0].NewRow();//0 is the index of the table in the DataSet
dr["name"]="Eli";
//in the same manner fill other cells
//when you have finished with filling the cells:
ds.Tables[0].Rows.Add(dr);//0 is the index of the table in the DataSet

When you are ready with the adding of the rows:

ds.WriteXml(@"xml data file full path");

When you want to load the above written data to a nwe dataset:

ds.ReadXml(@"xml data file full path");

NJoy! :)



Greetings,
Eli
-----------------------
If you know the enemy
and know yourself, you
need not fear the result
of a hundred battles.If
you know yourself but not
the enemy,for every
victory gained you will
also suffer a defeat.
If you know neither the
enemy nor yourself, you
will succumb in every battle.

Sun Tzu ,THE ART OF WAR