?
Solved

SQL and Vb.Net Doubt..

Posted on 2009-05-11
7
Medium Priority
?
232 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 1500 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

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:…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

800 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