Xml file to SqlSelect Statement - best practice help

Hot Topic

Play sound
ArrayList copying a class
Threads
What are some things to remember when drawing in Window Forms?
automatically select a combobox choice
how can I put in a procedure to download a file
What is the use of "STTBF".
Changing webbroswer Url
base.onPaint(e)
Adding formatted text to a RichTextBox at runtime

Visual C#

Outlook 2000 crashes on exit with WDS installed
notifyicon1 from disk
How to connect to catelog SQL-Server Full text search
no My object in c# ?
help me -- sound project --
Scrollbar
C# File signature
how to load and retrive an Image from ResourceManager ?
Add default formatting to new classes
using System.Drawing namespace in a Class Library Output

Xml file to SqlSelect Statement - best practice help

Hi all,

I am making a little reporting asp.net project and i need a bit of help.
I have xml files structured like this

<report>
<param name="startDate" type"SqlDbType.DateTime" />
<param name="company" type"SqlDbType.Text">
<item>Xyz Inc.</item>
<item>abc inc.</item>
</param>
<sql>
Sql here
</sql>
</report>

I have a class called Report that holds all the report's information once the XML has been loaded. I just need some help storing the parameters. Could i use something similar to SqlParameterCollection to convert and hold the XML Parameters (they need to be sql parameters before the query executes anyways) or should i store them as strings, or should i make a Class file for parameters and store them there.

Any help appreciated m

mcm




Answer this question

Xml file to SqlSelect Statement - best practice help

  • Gops Dwarak

    Whether or not to create a Class file for the parameters depends on your requirements. However, the most straight forward way to approach this is to:

    1. Create a SqlCommand
    2. Add the SqlParameters

  • Xml file to SqlSelect Statement - best practice help
Answer this question