Best Way to set up App

trying to figure out best way to store data

Page 1 of 1

4 Replies - 1270 Views - Last Post: 23 April 2009 - 01:57 AM Rate Topic: -----

#1 dragonseyeangie  Icon User is offline

  • New D.I.C Head

Reputation: -2
  • View blog
  • Posts: 41
  • Joined: 20-October 08

Best Way to set up App

Post icon  Posted 21 April 2009 - 09:05 AM

hello.

I am trying to build an application using vb.net that will serve as a very large checklist of sorts. and i'm not exactly sure of the best way to do this.

I considered using a database but i would need it to be self contained without having to rely on a server or internet connection.

I've also considered using collections and user settings. I've tested all of these things out to see which would be best but only the database makes sense to me.

Is there a way to have a database be self-contained?

Is This A Good Question/Topic? 0
  • +

Replies To: Best Way to set up App

#2 T3hC13h  Icon User is offline

  • D.I.C Regular

Reputation: 65
  • View blog
  • Posts: 337
  • Joined: 05-February 08

Re: Best Way to set up App

Posted 21 April 2009 - 09:16 AM

MySql, Firebird and SQLite all have embedded databases. Theres a .Net wrapper available for SQLite and I found it very easy to use.
Was This Post Helpful? 0
  • +
  • -

#3 Ian2009  Icon User is offline

  • New D.I.C Head

Reputation: 7
  • View blog
  • Posts: 31
  • Joined: 07-April 09

Re: Best Way to set up App

Posted 21 April 2009 - 10:21 AM

View Postdragonseyeangie, on 21 Apr, 2009 - 08:05 AM, said:

hello.

I am trying to build an application using vb.net that will serve as a very large checklist of sorts. and i'm not exactly sure of the best way to do this.

I considered using a database but i would need it to be self contained without having to rely on a server or internet connection.

I've also considered using collections and user settings. I've tested all of these things out to see which would be best but only the database makes sense to me.

Is there a way to have a database be self-contained?


You can also add a local SQL database to your project. It will be an mdf file and published together with your application. The advantage is you can design the database in visual studio.
Was This Post Helpful? 0
  • +
  • -

#4 pratham2003  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 9
  • Joined: 21-April 09

Re: Best Way to set up App

Posted 21 April 2009 - 10:11 PM

There are some problems i am going through when using local SQL database.
Like when i debug and try to insert records i dont know which database file is being updated... I know its being updated but where the database is stored while debugging... idk... maybe its in /obj/bin. will find out soon...

Also can i assign a userid / password to block access to the local database?
If password is not possible.. Someone suggested me to encrypt the data... Can someone give me a link to a tutorial / just tell what i need to know to encrypt data and possible blunders that i should not make...

This post has been edited by pratham2003: 21 April 2009 - 10:13 PM

Was This Post Helpful? 0
  • +
  • -

#5 jens  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 67
  • View blog
  • Posts: 430
  • Joined: 09-May 08

Re: Best Way to set up App

Posted 23 April 2009 - 01:57 AM

@dragonseyeangie

I think you should look at MSSQLCE (google) and maybe at my tutorial that shows how to create one from code. Otherwise it's quite simple to create one from the IDE. It's a one-file-database.

There are several tutors on VB.NET and different kinds of databases here at DIC.

Hope this helps! :)
/Jens

PS: @pratham2003 - It's possible to protect a MSSQLCE database with passwords.

This post has been edited by jens: 23 April 2009 - 01:59 AM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1