Solved

Database in project files.

Posted on 2008-10-09
6
238 Views
Last Modified: 2013-11-07
Hi Experts,

Is there a way of storing data in my application's project file(s) so it can be read with an OLEDB connection?

Cheers

Tom
0
Comment
Question by:TommyTwoPints
  • 3
  • 3
6 Comments
 
LVL 53

Expert Comment

by:Dhaest
ID: 22684670
What exactly do you want to store in your project-database ?

I'm not sure if this can help you
Database Projects in Visual Studio .NET
http://aspnet.4guysfromrolla.com/articles/071305-1.aspx
0
 
LVL 3

Author Comment

by:TommyTwoPints
ID: 22684705
Hi Dhaest.
My project is a winforms application that creates charts in PowerPoint from database tables. I would just like to know if rather than having the database tables in a seperate file; I could actually store the data in my project file that stores all the project information. At the moment the project file is in XML format but I guess this would have to be changed to accomodate this type of database. Unless I can read from XML using a connection string.
I just want to know if there is a way I can create my project files so they contain database tables that can be accessed by connection strings and commands.
Thanks
Tom
0
 
LVL 53

Accepted Solution

by:
Dhaest earned 500 total points
ID: 22684713
You can read a xml-file into a dataset and use this dataset to perform everything you want.

This is a very easy way to populate a dataset from an xml file. 
 
 
'load xml into a dataset to use here
Dim dSet As New DataSet
Dim fs As FileStream
 
 
'open the xml file so we can use it to fill the dataset
Try
   fs = New FileStream("C:\someXMLfile.xml, FileMode.Open)
Catch e As Exception
   Debug.WriteLine(e)
End Try
 
 
'fill the dataset
Try
   dSet.ReadXml(fs)
Catch ex As Exception
   Debug.WriteLine(ex)
Finally
   fs.Close()
End Try

Open in new window

0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 3

Author Comment

by:TommyTwoPints
ID: 22684748
Could you give me a few examples of working with the data set. Select, Insert & creating a view from the dataset would be nice.
Also; what happens if the XML file contains other settings that isnt related to the data I want to work with? Can I strip the XML containing the data into a memory stream and read the XML from there?
Thanks alot

Tom
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 22684787
0
 
LVL 3

Author Comment

by:TommyTwoPints
ID: 22684797
Thanks alot Dhaest, you've been a great help!
0

Featured Post

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question