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.

easier question first :)
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.
well there is a property called as Items on combo box ;
so if ur control is named as combobox1, u can do combobox1.Items
and u can iterate using a foreach loop and get the required item.
For your first question try using XMLWriter / XMLReader class instead of Filestream.

thanks, it work...:)

ck.

private void SaveData()
        {
            //Where is the xml data file?
            string tempFile = "DataFile.XML";

            //Open the XmlTextWriter
            XmlTextWriter tw = new XmlTextWriter(tempFile, null);
            //Open the File
            tw.WriteStartDocument();

            //Name the root element
            tw.WriteWhitespace("\n\t");
            tw.WriteStartElement("Enrolment");

            //First field 'Name'
            tw.WriteWhitespace("\n\t\t");
            tw.WriteStartElement("Name");
            tw.WriteString("George Washington");
            tw.WriteEndElement();

            //Next field 'Gender'
            tw.WriteWhitespace("\n\t\t");
            tw.WriteStartElement("Gender");
            tw.WriteString("Male");
            tw.WriteEndElement();

            //Close the file
            tw.WriteWhitespace("\n\t");
            tw.WriteEndDocument();
            //Close the TextWriter
            tw.Close();
        }

Notice the \n\t before each WriteString commands. This helps keep the XML file human compatible. If you never need to open the file up and look at it, using WordPad or another text editor, then you can omit these lines.

It is quite simple.

Happy Coding...