How to use an Xml file as a database?
-
Hi there! Can you people help me in using an Xml file as a Database... Thank you.
-
Hi there! Can you people help me in using an Xml file as a Database... Thank you.
You can't run SQL on it, unless you can import it into a dataset. You'd use XPath to search it instead.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "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 )
-
You can't run SQL on it, unless you can import it into a dataset. You'd use XPath to search it instead.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "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 )
hi i have two dates in my table, 03-23-2007 8:00:00 03-24-2007 8:00:00 I have two dropdown in my page use to filter between those two dates. i used to convert the two dates into CHAR CONVERT(CHAR(10),date,110) so the result is just "03/23/2007" and "03/24/2007" but the problem now is, when i filter the date like SELECT * FROM table WHERE date BETWEEN '03/23/2007' and '03/23/2007' returns no value but if my query is like : SELECT * FROM table WHERE date BETWEEN '03/23/2007' and '03/24/2007' it returs value but only the rows with the date '03/23/2007'. Any idea about that? Bernie