creating database tables without sql,oracle,access or any database software from vb.net

Question

0.00/5 (No votes)

See more:

I thank all my friends for the answer, the've been offering me on my questions.My quesiton is, I have been creating programs from vb.net thus programs which involves databases like sql,oracle or access. But when it gets to building and publishing the project for a client computer, it seems I will have to install my published setup from the project and also install a database program on the client computer before the program can run....Is there a way to create a project and create database tables in the vb.net project without using sql,oracle or access, so that I will not have to install a database software before the project software can work?In this way my project will not be depending on a database software to run.
How can I create database tables In vb.net just like tables in sql,oracle or access.

Posted 29-Aug-11 10:28am

TugBest

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jason Gleim · Accepted Answer · 2011-08-29T11:05:00

Solution 1

The entity framework and the LINQ data support like DataContext can be persisted to XML files pretty easily. This would let you implement 'Database' type functionality but persist the data to an XML file.

Alternately, you could require SQL Express on the client computer. It is just like the full-blown SQL and there are commands you can run against it (like CREATE DATABASE and CREATE TABLE) to create your entire data structure.

Posted 29-Aug-11 11:05am

Jason Gleim

Comments

TugBest 1-Sep-11 15:25pm

Thank you very much..Jason! Now am trying to create the database from the the localdatase item in vb.net thus SQL Express..but when I finish creating and conencting the database I then drag the tables onto the forms from the data source which gives me a binding source , table adaptor and binding Navigator., but when I run the project it gives me an error like(Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)..so in this way it displays the form alright but it doesn't have any of the records from the database I created .Please I need your help.

Jason Gleim 1-Sep-11 15:41pm

When I've seen this it is because of an issue with SQL Express running on x64. Make sure your project's target CPU is set to x86 rather than 'ANY CPU' or x64. The SQL compact libraries have to run under WOW on 64-bit systems and you have to force the project to target x86 (32-bit) to make that happen.

I *think* there is a service pack for SQL Express 2005 that addressed this... don't exactly remember. You may want to look around for that... not sure on SQL Express 2008 as I haven't run into this using that.

TugBest 2-Sep-11 9:23am

thank very much Jason.It worked perfectly God bless you

Jason Gleim 2-Sep-11 9:25am

Glad to hear you got it working! Good luck!

TugBest 2-Sep-11 9:34am

Jason I want to ask another question.This one is about crystal report.My question is I have developed a project using crystal report, and I want to install the build setup on a client computer. I have been able to build the setup from my project and installed it on the client computer but when I ask it to display the crystal report it gives me an (error not able to display crystal report) I tried installing crystal report separately from the vb.net setup file but it doesn't display the crystal report, but I had to install vb.net on the client computer before the crystal report could load.so I want help me to display my crystal report viewer on a client computer without installing the vb.net setup.I need Help.