How to get an xml from the gridview before passing to database

Question

0.00/5 (No votes)

See more:

--scenario

I have on gridview displayed and i have an insert button.

When i click on insert button, i should get the griddata in xml. And the same has to be passed to the database.

I tried searcing but didnot get the appropriate answer.

gridview details

userid     startdate           enddate
1        12/22/2013 13:30     12/22/2013 23:30
2        12/22/2013 13:30     12/22/2013 23:30
3        12/22/2013 13:30     12/22/2013 23:30

the same has to be passed in database table using stored procedure. I want to do it using stored procedure and also using xml.

xml in the sense : gridview details in xml format and fetch in stored procedure and insert in the table..

Kindly help me.

Posted 9-Dec-13 20:53pm

anurag19289

Add a Solution

Comments

Kriti Jain 10-Dec-13 4:42am

You have to first store the values of the grid in an object and after that you can covert that object into XML stream and pass it to the database.

anurag19289 10-Dec-13 13:22pm

i will try that and get back to you

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kriti Jain · Answer 1 · 2013-12-09T22:45:00

You can serialize the object using the following code

C#

public static string  Serialize<t>(object obj)  // Serializing the object to XML string
        {
            StringBuilder sb = new StringBuilder();
            using (TextWriter writer = new StringWriter(sb))
            {
                XmlWriterSettings settings = new XmlWriterSettings();
                settings.OmitXmlDeclaration = true;

                var serializer = new XmlSerializer(typeof(T));
                serializer.Serialize(XmlWriter.Create(writer, settings), obj);
            }
            string form = sb.ToString();
            return form;
        }