Denne code snippet er til at hente data ud fra en Access database 2003.

Filen skal gemmes som en xml fil og ligge i C: \ Program Files \ Microsoft Visual Studio 8 \ VC # \ Snippets \ 1033 \ Visual C #
Eller den mappe som nu måtte passe.!

Og som altid er der sprøgsmål så skriv.!
Den færdige xml fil kan hentes her

        //The following should be inserted into the top of the page before this snippet works
        //
        //using System.Data.OleDb;
        //
        //This snippet is made by Jimmy Nielsen @ sigenstrøm.dk / www.xn--sigenstrm-s8a.dk
        //The code is open source, so long as the code's / author's comments are not removed
        //If you use my code snippets, feel free to send me a mail or link to my website.
        //That way I can see how many people are using my snippets.
        //This is not a requirement ;-)
       
        //Converts the selected id to int
        int id = Set id;
       
        //you wish to select data by another field, then you must string the variabel by using this line insted of "int id = Set id;"
       
        //string id Set id;
       
        OleDbConnection MyConnection = new OleDbConnection();
        //Sets the path to the database
        MyConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|DatabaseName.mdb";
        //Here, data is retrieved from the table the selected id"
        string Mystring = ("Select * from TabelName where Id=" + id + "");
       
        //Use this line if you select data by another field
        //string Mystring = ("Select * from TabelName where Id='" + id + "'");
       
        OleDbCommand objCommand = new OleDbCommand(Mystring, MyConnection);
        OleDbDataReader objDataReader = null;
       
         try
            {



            //Opens the database connection
            MyConnection.Open();
            //The reader
            objDataReader = objCommand.ExecuteReader();

            //While the reader is open do this
            while (objDataReader.Read() == true)
            {
                //Here we come data from the database into text boxes, label or other
                SetData+= Convert.ToString(objDataReader["Selectcolumn"]);
            }


            //Closes the reader
            objDataReader.Close();
               

            }
            //Catches the errors
            catch (Exception exept)
            {
                //Prints error
                Response.Write(exept);
            }
            //Closes the connection to the database again
            MyConnection.Close();