Solved

SQL and Vb.Net Doubt..

Posted on 2009-05-11
7
228 Views
Last Modified: 2013-11-26
hi,

I want to create a Card collection program. There i have to store 4 imaes per card and many datas. Do i have to use SQL as backend? or is there any other way to do it? how to export the result in .CSV format?
0
Comment
Question by:Yogesh_Agarwal
  • 4
  • 3
7 Comments
 

Author Comment

by:Yogesh_Agarwal
ID: 24361220
if i used sql as backend, how can i distribut the application? do my users need sql server to run?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24361305
> Do i have to use SQL as backend?
you are not forced to do that, but it's much easier for the coding.
xml might be an alternative...

> do my users need sql server to run?
unless you make a central, globally available sql database, so everybody can connect to that same db, you have indeed to make the installation of your app also install the sql engine.
note: sql express has a silten install, to be included into your application setup.

your application then needs to be able to detect if the database is there, and if not, create it etc...
0
 

Author Comment

by:Yogesh_Agarwal
ID: 24361346
its a desktop application and i want to distribut that database along with my application.. i want to write some stored procedures and attach that database.. can u please guide me to how to do it? it shud be able to connect locally(in that system). and i want to attach that db with my application, and want to run the application.. i want to export and import database too. how to do it?
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 24361429
this is plenty of questions...

>and i want to attach that db with my application
what deployment software do you use?
you must include :
§ sql express setup
§ backup of your database, or the .mdf file, or some .sql files that can create the database as needed
and depending what method you choose, your application either needs to restore from the backup, attach the db, or run the .sql statements to get the database up and running.

you need to put some thought onto the fact that the end-user might want to reinstall or upgrade later without loosing it's database/data


0
 

Author Comment

by:Yogesh_Agarwal
ID: 24361728
>>> what deployment software do you use?

I use Visual Studios in built setup project. I will take my database backup and attach to application.. is it ok? i heard that .Net 3.5 REdis Includes SQL engine.. is it true?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24362137
>i heard that .Net 3.5 REdis Includes SQL engine.. is it true?
I don't know, sorry. stuck with .net 2.0 here :(
0
 

Author Closing Comment

by:Yogesh_Agarwal
ID: 31580410
good
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

860 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