• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • Last Modified:

VB2005 create database

Hi, need to create database in vb2005 . A customer record that is retrievable and can be saved . Any ideas ?

How is VB2005 is different from other VB versions?
0
mahmood_786
Asked:
mahmood_786
  • 6
  • 4
  • 2
  • +2
3 Solutions
 
leonstrykerCommented:
What kind of a database? What is your experience level? What have you worked with previously?
0
 
hesCommented:
Do you mean vb 2005.net ?
0
 
mahmood_786Author Commented:
Yes vb2005.net ,I have no experience data building .
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Bob LearnedCommented:
It would be easier to provide possible solutions, if you provided more details for your requirements.

1) Database type (SQL Server database file, Access database, ...)

2) Application type
0
 
mahmood_786Author Commented:
well it will save the cusotmer detais and provid ethe quotation for them for finance to buy a car, it can be strored , deleted, and  retreived(the quote), The databse can be in microsoft excel , if not it will be in access, please consider ms excel as it is easy.
0
 
Bob LearnedCommented:
If you are working with Access, you can create a database with DML (Data Manipulation Language).  If you are working with Excel, you can create a workbook with Excel interop, but it gets messy if you are working with different versions of Excel.
0
 
aikimarkCommented:
>>The databse can be in microsoft excel...
It could be a flat file (CSV) or tagged file (XML).
It could be a non-SQL database (Mongo).

>>...as it is easy
Easy in what respect?
0
 
mahmood_786Author Commented:
Easy : less coding and easy to understand
0
 
mahmood_786Author Commented:
How I save and retrieve in vb.net ? Which commands are used and what is the command to delete?
0
 
aikimarkCommented:
I guess the simplest solution would be to use a datalist and its serialization methods to/from XML
http://support.microsoft.com/kb/316730
0
 
mahmood_786Author Commented:
But it does not tell how can I can save ,retriev eand delete, I have found another article
http://devcity.net/Articles/113/1/dotnet_serialization.aspx
but same problem. any advice  i am new to this

0
 
aikimarkCommented:
Did you follow the link to the examples page?
http://msdn.microsoft.com/en-us/library/aa719523.aspx

Note: the VB code includes some mis-tagged C# code (ignore the code after [C#])
0
 
mahmood_786Author Commented:
Thanks, i suppose this code does saves and i can save new files. if i want to run this code do i have to use console  application? also which set of the code i have to use?
0
 
aikimarkCommented:
@mahmood_786

Rather than writing a program, why don't you just use Access?  

It is obvious that you are very early in your development career.  As such, you should decide the best use of your time -- solving a problem or learning to program.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 6
  • 4
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now