Need to delete a record/all of an xml database.

Posted on 2011-10-03
Last Modified: 2012-05-12
I have xml file,

I am looking to format it using linq but dot know how

delete * from student.xml

and also looking to delete individual records based on student id

delete * from student.xml whre studentid='5993153492'

something along those lines.

<?xml version="1.0" standalone="yes"?>
    <StudentName />
    <StudentID />
    <Image />
    <Location />
    <SmartSpeech />
    <StudentName>Corey Gashlin</StudentName>

Open in new window

Question by:desiredforsome
    LVL 22

    Expert Comment


    Author Comment

    I like examples. any ideas?
    LVL 83

    Accepted Solution


    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (…
    Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now