Re: Problem in deployment urgent - C# Discussion Boards

Re: PLZ I Want to used xml file as database( how to add,update,delete and Search)

6-Oct-07 13:31

You can want all you want. It's not going to change the fact that XML is NOT a database. You cannot use SQL statements to navigate through the tables. You have to use the various XML methods to modify your tables, but XML is very inefficient at it.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Christian Graus6-Oct-07 13:49

Re: PLZ I Want to used xml file as database( how to add,update,delete and Search)

6-Oct-07 13:49

Dave Kreskowiak wrote:
You can't want all you want.

I don't think that is what you meant... :P

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Dave Kreskowiak6-Oct-07 15:42

Re: PLZ I Want to used xml file as database( how to add,update,delete and Search)

6-Oct-07 15:42

Whoops. I knew that didn't look right when I posted it...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Christian Graus6-Oct-07 13:33

Re: PLZ I Want to used xml file as database( how to add,update,delete and Search)

6-Oct-07 13:33

Unless your data set is very small, this smells of disaster. XPath is how you search XML. The DOM via the XMLDocument class is how you interact up add/update/delete/search.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

BAIJUMAX7-Oct-07 5:35

BAIJUMAX

7-Oct-07 5:35

If You really want you can.Once again Is that you really want to do.

check DataSet members ReadXML()/WriteXML()

load XML Store to Dataset using ReadXML ( on Application Initialization )

Manipulate ( add/delete etc.. ) this DataSet during application life cycle.

On ApplicationExit use WriteXML.

"Sometimes solutions will be as simple as 1=1 , confused right D'Oh! | :doh:

"

By
BAIJUMAX

Problem in deployment urgent

Shuaib wasif khan6-Oct-07 12:36

Shuaib wasif khan

6-Oct-07 12:36

how to deploy a project which expires after one month.means how to make a demo application
how to give company name ,version when deployinga project.

monu_khan in trouble

Christian Graus6-Oct-07 13:07

6-Oct-07 13:07

You can't do that via your deployment, you have to create a demo version. And, you need to ask yourself who your market is. A simple way is just to store the install date somewhere, and check if 30 days have passed. People can get by this by setting their clock back, or just by decompiling your app and removing the check. If your clients are likely to do that, then it's a whole lot harder, but a basic 30 day check is trivial to do.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Paul Conrad7-Oct-07 5:46

Paul Conrad

7-Oct-07 5:46

Do not use the word 'urgent' in your post, it is considered rude. It only will anger most people. Most members on this site come here on their own free-will and are not obligated to replying with rude requests like 'urgent'

"Find it your bloody self - immediately!" - Dave Kreskowiak

Pete O'Hanlon7-Oct-07 10:40

Pete O'Hanlon

7-Oct-07 10:40

Well said.

Deja View - the feeling that you've seen this post before.

Access properties from a class not belonging to the namespace

Paul Conrad7-Oct-07 11:05

Paul Conrad

7-Oct-07 11:05

Needed to get somewhat verbose instead of the typical Don't say urgent style of posts.

"Find it your bloody self - immediately!" - Dave Kreskowiak

ESTAN6-Oct-07 9:56

ESTAN

6-Oct-07 9:56

Hello,

I have a class without a namespace. The main reason why I don't have a namespace in that class is because I use that class in all my applications.
Now I like to update application settings in that class, but I don't like to use the following line in that class:

using ApplicationNamespace.Properties;

Is there a way where i can reference that up to my class?

Re: Access properties from a class not belonging to the namespace

Dave Kreskowiak6-Oct-07 13:35

Re: Access properties from a class not belonging to the namespace

6-Oct-07 13:35

You may think that your class is not contained in a namespace, but it IS in one. The default name for a namespace is the name of the project.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

ESTAN6-Oct-07 13:42

ESTAN

6-Oct-07 13:42

Well, that's the point, i would like to be able to copy the class everywhere without changing/adding the projects namespace into the class and still updating the namespace's settings.

Maybe it is impossible, but i like to ask.

Re: Access properties from a class not belonging to the namespace

Christian Graus6-Oct-07 13:50

Re: Access properties from a class not belonging to the namespace

6-Oct-07 13:50

Yeah, it is, you can't change the namespace your code is in.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Dave Kreskowiak6-Oct-07 15:45

6-Oct-07 15:45

Like Christian said, you can't do that. The namespace is part of the fully qualified name of the class. Changing it is out of the question.

The only way you can use this class in other projects is to add a reference to it's .DLL. Importing the namespace is optional, but it saves you from having to type the full namespace/class path in your other project's code.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

reading xml values

jon-806-Oct-07 9:25

6-Oct-07 9:25

I'm trying to read an xml file that appears to be valid xml, however, the attributes don't seem to be read by an System.Xml.XmlTextReader.

Any idea why?

I couldn't paste the .xml file here because it seems to corrupt the forum, but I can send it; it's a small file.

.NET Framework 2.0
Code
----

using System;

using System.Xml;

namespace ReadingXML2
{

    class Class1
    {

        static void Main(string[] args)
        {

            int ws = 0;

            int pi = 0;

            int dc = 0;

            int cc = 0;

            int ac = 0;

            int et = 0;

            int el = 0;

            int xd = 0;

            // Read a document

            XmlTextReader textReader = new XmlTextReader("sample.xml");

            // Read until end of file

            while (textReader.Read())
            {

                XmlNodeType nType = textReader.NodeType;

                // If node type us a declaration

                if (nType == XmlNodeType.XmlDeclaration)
                {

                    Console.WriteLine("Declaration:" + textReader.Name.ToString());

                    xd = xd + 1;

                }

                // if node type is a comment

                if (nType == XmlNodeType.Comment)
                {

                    Console.WriteLine("Comment:" + textReader.Name.ToString());

                    cc = cc + 1;

                }

                // if node type us an attribute

                if (nType == XmlNodeType.Attribute)
                {

                    Console.WriteLine("Attribute:" + textReader.Name.ToString());

                    ac = ac + 1;

                }

                // if node type is an element

                if (nType == XmlNodeType.Element)
                {

                    Console.WriteLine("Element:" + textReader.Name.ToString());

                    el = el + 1;

                }

                // if node type is an entity\

                if (nType == XmlNodeType.Entity)
                {

                    Console.WriteLine("Entity:" + textReader.Name.ToString());

                    et = et + 1;

                }

                // if node type is a Process Instruction

                if (nType == XmlNodeType.Entity)
                {

                    Console.WriteLine("Entity:" + textReader.Name.ToString());

                    pi = pi + 1;

                }

                // if node type a document

                if (nType == XmlNodeType.DocumentType)
                {

                    Console.WriteLine("Document:" + textReader.Name.ToString());

                    dc = dc + 1;

                }

                // if node type is white space

                if (nType == XmlNodeType.Whitespace)
                {

                    Console.WriteLine("WhiteSpace:" + textReader.Name.ToString());

                    ws = ws + 1;

                }

            }

            // Write the summary

            Console.WriteLine("Total Comments:" + cc.ToString());

            Console.WriteLine("Total Attributes:" + ac.ToString());

            Console.WriteLine("Total Elements:" + el.ToString());

            Console.WriteLine("Total Entity:" + et.ToString());

            Console.WriteLine("Total Process Instructions:" + pi.ToString());

            Console.WriteLine("Total Declaration:" + xd.ToString());

            Console.WriteLine("Total DocumentType:" + dc.ToString());

            Console.WriteLine("Total WhiteSpaces:" + ws.ToString());

        }

    }

}

Program output
--------------
Element:database
WhiteSpace:
Element:table
WhiteSpace:
Element:column
WhiteSpace:
WhiteSpace:
Element:column
WhiteSpace:
WhiteSpace:
Element:column
WhiteSpace:
WhiteSpace:
WhiteSpace:
Element:table
WhiteSpace:
Element:column
WhiteSpace:
WhiteSpace:
Element:column
WhiteSpace:
WhiteSpace:
WhiteSpace:
WhiteSpace:
Total Comments Blush | :O

Total Attributes Blush | :O

Total Elements:8
Total Entity Blush | :O

Total Process Instructions Blush | :O

Total Declaration Blush | :O

Total DocumentType Blush | :O

Total WhiteSpaces:16
Press any key to continue . . .

Jon

pmarfleet6-Oct-07 11:44

pmarfleet

6-Oct-07 11:44

Check 'Ignore HTML tags in this message' to post your XML.

Paul Marfleet

jon-806-Oct-07 13:09

6-Oct-07 13:09

I posted the .xml file I think...

Jon

jon-806-Oct-07 21:21

6-Oct-07 21:21

<?xml version="1.0"?>
<database schema-name='products'>
<table name='ProductsInStock'>
<column data-type='text' name='Code' pk='true' fkreferences='Product.Code'>
</column>
<column data-type='int' name='Qty'>
</column>
<column data-type='currency' name='CostPrice'>
</column>
</table>
<table name='Product'>
<column data-type='text' name='ProductID' pk='true'>
</column>
<column data-type='text' name='Description'>
</column>
</table>
</database>

Jon

pmarfleet6-Oct-07 22:06

pmarfleet

6-Oct-07 22:06

This code should work

static void Main(string[] args)        
        {
            int ws = 0;  
            int pi = 0;  
            int dc = 0;        
            int cc = 0;       
            int ac = 0;       
            int et = 0;       
            int el = 0;       
            int xd = 0;       
            // Read a document  
            XmlTextReader textReader = new XmlTextReader("../../sample.xml");     
            // Read until end of file     
            while (textReader.Read())        
            {            
                XmlNodeType nType = textReader.NodeType;
                // If node type us a declaration  
                if (nType == XmlNodeType.XmlDeclaration)           
                {                  
                    Console.WriteLine("Declaration:" + textReader.Name.ToString());     
                    xd = xd + 1;         
                }             
                // if node type is a comment  
                if (nType == XmlNodeType.Comment)        
                {            
                    Console.WriteLine("Comment:" + textReader.Name.ToString());                          
                    cc = cc + 1;      
                }                         
                // if node type is an element   
                if (nType == XmlNodeType.Element)  
                {                   
                    Console.WriteLine("Element:" + textReader.Name.ToString());    
                    el = el + 1;
                    if (textReader.HasAttributes)
                    {
                        while (textReader.MoveToNextAttribute())
                        {
                            Console.WriteLine("Attribute:" + textReader.Name.ToString());
                            ac = ac + 1;
                        }
                    }
                }         
                // if node type is an entity\ 
                if (nType == XmlNodeType.Entity)   
                {                
                    Console.WriteLine("Entity:" + textReader.Name.ToString());   
                    et = et + 1;      
                }           
                // if node type is a Process Instruction      
                if (nType == XmlNodeType.Entity)      
                {            
                    Console.WriteLine("Entity:" + textReader.Name.ToString());  
                    pi = pi + 1;            
                }               
                // if node type a document         
                if (nType == XmlNodeType.DocumentType)   
                {                   
                    Console.WriteLine("Document:" + textReader.Name.ToString());       
                    dc = dc + 1;    
                }             
                // if node type is white space     
                if (nType == XmlNodeType.Whitespace)       
                {                 
                    Console.WriteLine("WhiteSpace:" + textReader.Name.ToString());   
                    ws = ws + 1;      
                }      
            }          
            // Write the summary  
            Console.WriteLine("Total Comments:" + cc.ToString());      
            Console.WriteLine("Total Attributes:" + ac.ToString());   
            Console.WriteLine("Total Elements:" + el.ToString());     
            Console.WriteLine("Total Entity:" + et.ToString());      
            Console.WriteLine("Total Process Instructions:" + pi.ToString());     
            Console.WriteLine("Total Declaration:" + xd.ToString());        
            Console.WriteLine("Total DocumentType:" + dc.ToString());     
            Console.WriteLine("Total WhiteSpaces:" + ws.ToString());      
        }

The XmlTextReader has specific methods for iterating through Attributes. Use these when you encounter an Element node.

Paul Marfleet

jon-806-Oct-07 22:20