Solved

SQL and Vb.Net Doubt..

Posted on 2009-05-11
7
230 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
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

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

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…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
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: …

717 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