Eng

Does that tool have the PIVOTING capabilities? We are looking for reporting tool with this sort of functionality. ET

Hello experts! HELP...please. Most of the articles that I have been reading are not on dataset and a few of the articles I found on dataset are over my little head. :confused: If I can see the walkthrough example, I am hoping to comprehend better. I need to create a binary serialized dataset in my application. The reason is because some of our data files are very very huge and XML files only triple the actual size of the data. The basic thing that I am doing in my application is a simple (SELECT * ) from a table and capturing the result into the Dataset. Now...I just need to serialized that dataset into a file so I can deploy with the application, and deserialize that dataset when the client opens my application. Thanks in advance!

Ok...it sounds like you understood my question:-) Based on the snippet schema example you gave me, if I were to load the dataset with the ReadXmlSchema method, then the datset that I have loaded will already have the "Relation" called [CustomerOrder] as its RelationName...correct? From the schema, will it also know which is the Parent Table/Column and which is the Child Table/Column?

No...the plan is for the third party to sent us their data in the XML File Format. According to them, they will be able to set up the relations within their XML File (Elements/Tables) using the XREF(?) when they sent us the XML File and the schema. I was able to successfully read in the "simple" XML file with the mapping of the schema file into the Dataset, using the XMLDocument Object. Now, I am trying to see if I could read in the "realation" XML file with the mapping of the schema file into the Dataset. Basically, I am trying to answer my question of "Will the relations in the XML file that the client sent be able to read in correctly as DataRelations into the Dataset?" Since I have never seen the "relation" XML File (our client hasn't sent us one yet), I wanted to stay ahead of the game by finding the "How's". I couldn't find any examples or tutorials on doing such ...yet.

Has anyone worked with an XML Files that has the relations set-up between each elements within the file? I am curious as to, how the XML File and its schema look like for this type of XML. I have only seen the simple Hierarchial XML documents and I am wondering if anyone could shed lights on this. I need to experiment with reading the relational XML documents into the ADO Dataset and I don't have any good examples to based on. My curiousity is killing me. Thanks!

Thank you. Boy...there is just too much to keep up with even when I think I know VB, VB.NET is a different world.

Hi All, I am trying to convert my VB.NET to C# (for learning purpose) and I cannot seem to find the equivalent functions for Instr() and Mid() that I had used in VB.NET to be applied to C#. Can anyone tell me what the functions are to do those two functions in C#? InStr() ==> This function looks for a string within another string and returns the position where a match is found. Mid() ==> This function function returns a specified number of characters from a string beginning at a given point. Thanks in advance!

Thanks. I tried all the leads that you'd offered. (even modifying their schema line) Still getting the same error. Uggghhhh... If I take out their "Includes" reference and just cut and paste all the info from their INCLUDE files into the Main XSD, it works. So it has to be something along the line of referencing the include files. Thanks anyway. But if you find or recall anything else that I should try, I'd appreciate it.

Do you mean to say "XSD" File instead of "XSL"? Do I need to do anything else withe TargetNamesapce and all that attributes that are already in the schema that they had sent?

I know this forum is not about XML specific in details. But...maybe those with lots of experince in working with XML files have come across this and could shed some lights on me. We have received schema files from the third party and I am trying to read the schema into the dataset using the "XmlDataDocument" object. However, out of the (3) schema files that we are receiving, (1) is the main file that references the other (2) schema files as "includes". For some reason, I am getting "undeclared reference" during the read on=f the main schema file when ever it gets to the point where it is referring to something in the "include" files. Is there anything specific that I need to do with the Include files? HELP!

I am assuming there is no way to do this? Isn't there some component or even .NET assembly that I could call to figure out what my local system DSN set-ups are? The reason I need to do this is we are writting the application with .NET but our backend is RedBrick Database. Therefore, our users log on using ODBC Connection using their DSN names. I need to, somehow, prompt them after they log into the front-end application before accesing the back-end database. I am sure some genius here knows how to do this. HELP!!

Thank you! The site should give me a good jump start.

I guess my questions were too general. I wil not be writing to the XML file. Here is an expansion to my questions: 1.) We are planning to receive some XML files, along with their schema, from another party. The original files (XML, XSD) that we are receiving currently do not have any sort of identifier as to if any 'relations' exists within each element within the XML data. Looing at the data, we know that there are "relations" among those elements. Since I don't know much about the XML technology, I wanted to know if setting the relations could be done within the XML/XSD files -- before asking the third party to give us that sort of format in their file. I am not sure how they get thier XML/XSD files created so this may not be .NET specific, but XML technology in general. 2.) If let's say, the third party can provide us with the "relation" information in thier XML/XSD files ( I am being optismistic here), I am wondering if I read their files into the ADO Dataset, will it recognize the 'relations' given from thier files? In other word, without adding the relations in my dataset manually -- but, read it programmatically using their XML/XSD files. I haven't seen any examples on doing that.

I don't know much about this XML stuff other than the buzz words that accompany it, such as XSD and XSLT. I am trying to find out if there a way to capture the relational data information into a XML File? For instance, say for simplicity sake, I have a customer information(from Customer Table) and the order information (from Order Table). In my relational database, I have Customer Key as Primary Key to the Customer Table and it is a Foreign Key to the Order Table. 2 questions: 1.) If I have the data in XML file that keeps track of each customer and their orders, how/where will that relation show up? Will that be in the XSD Schema? 2.) Is it possible (any example) to read the XML/XSD file that contains the relation information into an ADO.NET dataset with the same relation being captured? Any help, solution or direction, to the answers to my questions, is appreciated.

Thanks for your time by answering all my questions. My task this weekend is to get a good C# book and get the ball rolling!! Thanks again!!