Comments by angelvarun (Top 20 by date)

There are 34 funds and i am getting only 16 fund columns...

Thanks a lot digimanus. I can see the format of result i want, but i am able to see the duplicate rows, i will try to modify ur given query and will get back to you once i feel helpless. Thanks again

Hi digimanus,
I have modified my question and now it should be easy for you to help me with the query. Can you please help me out?

I will need to first make a simple query of what data i want and then i would give you that result set and the query. So you would be able to work only after that. I will get back to you shortly. Thanks mate..

Hi Sudip,

Thanks for your suggestion. I wanted the logic of pivot to use multiple table. Are you referrring to datatable object of .net? If so then i have the idea that i can create customised datatable by different sql queries like in ds[0].tables[0] ,ds[0].tables[1] etc but it would be very complex one and bit old.

Thanks digimanus. i had a look into the queries. i was looking for some queries using multiple tables like
select t1.column1, t2.column from table t1, table2 ...

and i could not see multiple tables in your query, as you know i want the matrix /pivot using multiple table, do you have any such handy query. I am not a sql expert so felt bit difficult to modify your query using one table to make it work for me.

Hi Bob,
Unfortunately the html is added by client.

Hi SAKryukov,

Thanks for replying. My string is a big string and it can increase in size and it's not exactly well formed xml. But you can say its bit HTML type. So i was just looking for help regarding manipulating the anchor tags in it and then getting the modified string variable.

Hi Rajesh,
Thanks for the reply. But i feel that attributes will be ignored in this way, by attributes i mean , if you see the reports node there are attributes like iconfile and highlightcolor.

Didn't get you exactly..

Below is my code:

XmlDocument objDoc = new XmlDocument();
objDoc.Load(Server.MapPath("AngloMap.xml"));
if (!string.IsNullOrEmpty(TreeView2.SelectedNode.DataPath))
{
XmlNode node = objDoc.SelectSingleNode(TreeView2.SelectedNode.DataPath);
txtEditXML.Text = node.InnerXml;
Session["CurrentEditXpath"] = TreeView2.SelectedNode.DataPath;
}

Hiya, I cant give the tool to client :) else for future requirements they wud nt contact us :) I have created few applications where I was trying to display the xml file in gridview and then trying to manipulate it and til some extent it worked for simple structures, i also created a tree structure where i added the nodes and stored it in db but thought it wud get complex when atttributes and values wil get added, also a db structure to store that stuff was not a gud idea for me. I also tried to create a UI where i gave add node, edit node button and then using xml DOM structure adding and updating the nodes, but as i have a requirement where I have complex xml file, i need an application similar to treeview kind of structure which is too handy for user. So i thought if some1 wud have got such a requirement then that code wud be ready and i wud not have to re-invent the wheel..

Here I get my answer :

http://support.microsoft.com/kb/317666

Now the challenge is how to make a UI which allows user to enter the values and attributes they want to add,remove, and modify.

No worries. I appreciate your efforts :)

@dawmail333- thanks for the suggested solution.In this case number of classes will increase as the xml has a healthy hierarchy. i was looking for some easy solution like getting the values from the UI and storing them in sql server db and then getting the xml using ds.getxml or ds.writexml....