Solved

SQL and Vb.Net Doubt..

Posted on 2009-05-11
7
225 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
Comment Utility
if i used sql as backend, how can i distribut the application? do my users need sql server to run?
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
> 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
Comment Utility
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
Comment Utility
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
Comment Utility
>>> 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 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
>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
Comment Utility
good
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now