[Ecstatic]

I am creating a website with asp.net and sql server 2008. I used count() to count number of rows in a table and returned the result in a label. The label does show 43(counted rows) on the web page but I cannot use label.text anywhere in the code afterwards because it says its in invalid format. When I debug it i see this string stored in the label:

<NewDataSet>
<Table1>
<Column1>43</Column1> 
</Table1>
</NewDataSet>

The Code I have written is:

        mainprog y = new mainprog();  //mainprog is the main class I have (C#)
        DataSet d = null;
        d = y.stdcount();             //stdcount() is the function for counting number of rows in table
        stdno.Text = d.GetXml();      //stdno is the label I am using to output the value of count

After this I have to use that count as an argument in the next function. How can I separate count from the above string?
I will be thankful for any help...

[Atli]

** Moved to ASP.NET **

[Frinavale]

Use the XmlDocument class to help work with the XML.

You can retrieve the XmlNode that you are looking for and then retrieve it's value using the XmlNode.

Check out the documentation for more details

-Frinny