| Groups | Blog | Home |
dotnet general : Access database to XML
From there you can use DataSet.WriteXML("SomePath") to create an XML file, and myDataSet.ReadXML("SomePath") to get it into a Dataset If you look at my post here (mullahbill is my forum name) http://forums.devbuzz.com/tm.asp?m=24284&p=11&tmode=1&smode=1 I show an example of how to do this... Remember though if you are new to PPC, that the filesystem is different...no C:\ drives or such, HTH, Bill [quoted text, click to view] "EMW" <someone@microsoft.com> wrote in message news:3fa93886$0$79348$5fc3050@dreader2.news.tiscali.nl... > Hi > > Is it possible to convert a MDB access database to a XML (sheet/something)? > I'm very new with XML, thus I don't know all its possibilities. > I'm writing a program for my PDA and since it is not possible to open the > CDB database with .NETCF, I'm looking for other possibilities then buying > 3rd party (inthehand) software. > > thanks, > Eric > >
Hi
Is it possible to convert a MDB access database to a XML (sheet/something)? I'm very new with XML, thus I don't know all its possibilities. I'm writing a program for my PDA and since it is not possible to open the CDB database with .NETCF, I'm looking for other possibilities then buying 3rd party (inthehand) software. thanks, Eric
You aren't a pain, no worries...
1) If you are used to standard queries, you cna use a product by Inthehand that's an ADOCE wrapper. While I have not used it personally, I know many that have and the reviews are universally that the product is excellent and the guy that wrote it is very visible and well respected in the CF world. 2) You can also use SQL Server CE which is a great solution. If you search on SQL Server CE there are a few good example out there, but Rob Tiffany just came out with a new book on the subject...I just wrote a review on it here http://www.devbuzz.com/content/books.asp and it's available at a 30% discount. 3) If you want to use XML here's a basic strategy. The whole goal is to use Data in a DataSet and the dataset doesn't care where it comes from (the data). It can come from SQL Server, CE, a text file, an XML file etc. So, on the desktop, you fire a query and build a dataset that has all the data you need. Then, use DataSet.WriteXML("SomePath"); Then, copy via your method of choice the XML file to the PDA. Once it's there, you declare a new dataset and call the ReadXML ie myDataSet.ReadXML(@"\Storage Card\myData.xml"); Now that data is available on the PDA. I'd recommend making the dataset a public property so you can acccess it throughout. you can add all you want to it and then when you are done, write the new XML back to the storage card, sync the file back to the desktop and use it to update your database. It sounds much more complicated than it is. You can also use the tables of the Dataset to create other objects like Dataviews to facilitate searching and filtering.... HTH, Bill [quoted text, click to view] "EMW" <someone@microsoft.com> wrote in message news:3faa5a2c$0$79333$5fc3050@dreader2.news.tiscali.nl... > Ok, I read the thread, but I'm now puzzled. > With this methode I first make my query, then put it on the PDA and then > read it? > > What I need to do is to create a list of records in which my PDA program > makes a search. > I.e. I work at a mobile communications firm and we have a few thousend sites > all over the country. > Each site has a 4 digit number and the user of my program enters this number > in the textbox. > Then he taps on "search" and he will get the address and some more info. > > Right now it is done by a sql-query in a ADOCE connection object, but since > cdb is not supported in .NETCF, > I need some other way to do this. > I figured XML is the easiest??? > > So can I make an XML file of the database info (created from an EXCEL sheet) > and then make some kind of query inside this XML page? > Can I create a new XML sheet based on the original XML file with the > criteria for the seach? > > I hope I'm not too much of a pain in the a.. ;) > > rg, > Eric > > > "William Ryan" <dotnetguru@comcast.nospam.net> schreef in bericht > news:uX73FF9oDHA.2416@TK2MSFTNGP10.phx.gbl... > > You can grab all of your tables in the Database and put them in a DataSet. > > From there you can use DataSet.WriteXML("SomePath") to create an XML file, > > and myDataSet.ReadXML("SomePath") to get it into a Dataset > > > > If you look at my post here (mullahbill is my forum name) > > http://forums.devbuzz.com/tm.asp?m=24284&p=11&tmode=1&smode=1 I show an > > example of how to do this... > > > > Remember though if you are new to PPC, that the filesystem is > different...no > > C:\ drives or such, > > > > HTH, > > > > Bill > > "EMW" <someone@microsoft.com> wrote in message > > news:3fa93886$0$79348$5fc3050@dreader2.news.tiscali.nl... > > > Hi > > > > > > Is it possible to convert a MDB access database to a XML > > (sheet/something)? > > > I'm very new with XML, thus I don't know all its possibilities. > > > I'm writing a program for my PDA and since it is not possible to open > the > > > CDB database with .NETCF, I'm looking for other possibilities then > buying > > > 3rd party (inthehand) software. > > > > > > thanks, > > > Eric > > > > > > > > > > > >
Thanks!
"William Ryan" <dotnetguru@comcast.nospam.net> schreef in bericht news:uX73FF9oDHA.2416@TK2MSFTNGP10.phx.gbl... [quoted text, click to view] > You can grab all of your tables in the Database and put them in a DataSet. > From there you can use DataSet.WriteXML("SomePath") to create an XML file, > and myDataSet.ReadXML("SomePath") to get it into a Dataset > > If you look at my post here (mullahbill is my forum name) > http://forums.devbuzz.com/tm.asp?m=24284&p=11&tmode=1&smode=1 I show an > example of how to do this... > > Remember though if you are new to PPC, that the filesystem is different...no > C:\ drives or such, > > HTH, > > Bill > "EMW" <someone@microsoft.com> wrote in message > news:3fa93886$0$79348$5fc3050@dreader2.news.tiscali.nl... > > Hi > > > > Is it possible to convert a MDB access database to a XML > (sheet/something)? > > I'm very new with XML, thus I don't know all its possibilities. > > I'm writing a program for my PDA and since it is not possible to open the > > CDB database with .NETCF, I'm looking for other possibilities then buying > > 3rd party (inthehand) software. > > > > thanks, > > Eric > > > > > >
Ok, I read the thread, but I'm now puzzled.
With this methode I first make my query, then put it on the PDA and then read it? What I need to do is to create a list of records in which my PDA program makes a search. I.e. I work at a mobile communications firm and we have a few thousend sites all over the country. Each site has a 4 digit number and the user of my program enters this number in the textbox. Then he taps on "search" and he will get the address and some more info. Right now it is done by a sql-query in a ADOCE connection object, but since cdb is not supported in .NETCF, I need some other way to do this. I figured XML is the easiest??? So can I make an XML file of the database info (created from an EXCEL sheet) and then make some kind of query inside this XML page? Can I create a new XML sheet based on the original XML file with the criteria for the seach? I hope I'm not too much of a pain in the a.. ;) rg, Eric "William Ryan" <dotnetguru@comcast.nospam.net> schreef in bericht news:uX73FF9oDHA.2416@TK2MSFTNGP10.phx.gbl... [quoted text, click to view] > You can grab all of your tables in the Database and put them in a DataSet. > From there you can use DataSet.WriteXML("SomePath") to create an XML file, > and myDataSet.ReadXML("SomePath") to get it into a Dataset > > If you look at my post here (mullahbill is my forum name) > http://forums.devbuzz.com/tm.asp?m=24284&p=11&tmode=1&smode=1 I show an > example of how to do this... > > Remember though if you are new to PPC, that the filesystem is different...no > C:\ drives or such, > > HTH, > > Bill > "EMW" <someone@microsoft.com> wrote in message > news:3fa93886$0$79348$5fc3050@dreader2.news.tiscali.nl... > > Hi > > > > Is it possible to convert a MDB access database to a XML > (sheet/something)? > > I'm very new with XML, thus I don't know all its possibilities. > > I'm writing a program for my PDA and since it is not possible to open the > > CDB database with .NETCF, I'm looking for other possibilities then buying > > 3rd party (inthehand) software. > > > > thanks, > > Eric > > > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
| home · blog · groups | Questions? Comments? Contact the dn |