I've doing what I would think would be a very common use of ADO.Net, but I cannot find much info on this in any of my book or online. What I'm doing seems pretty simple.
I have an app that can run in both a disconnted and connected state. When it is disconnected, it is disconnected from the SQL DB. My client machine does not have access to a local database, so I am using XML on the client. I am loading the XML into datasets to be processed. The problem I'm running into is that I cannot easily perform the same SELECT statements against the datasets that I can perform against SQL Server. For example, lets say that I have the following SQL SELECT statement... SELECT * FROM table1 If I bring a copy of table1 from SQL server to the client machine and save it as XML, I can reload the dataset using the local copy of XML. Reload the XML will recreate the same dataset as the SQL SELECT statement created with I was connected to the Server. However, take the following SQL statement.. SELECT ID, rtrim(ltrim(FirstName + ' ' + LastName, FROM table1 WHERE userid = '1' OR userid = NULL What options do I have in loading table1 into a dataset and them recreating this same SQL statement? What if the SQL statement was even more complex with 3 or 4 tables, a few JOINS, etc? Do I have to build the dataset tables individually, then set up relationships, and them perform simple SQL statements one at a time while creating new datasets with each result? That seems to be the way the books show you. However, that seems to be a major pain. I might as well right XML parsing code to handle it. Maybe creating a new dataset from SQL when the user is last connected, but create one with the JOINS already in place. Then just use multiple table().Select () statements to drill into the records I need. What do you think is the best way to handle this sort of logic? Any ideas would be very much appreicated. I want to make sure I approach this one correctly so I do not need to rewrite it down the road. I also want to understand what options I have to make sure I am not missing something that would make this pretty easy to code. Best regards, Jon =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
