Solved

VB2005 create database

Posted on 2011-03-06
15
494 Views
Last Modified: 2012-05-11
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
Comment
Question by:mahmood_786
[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
  • 6
  • 4
  • 2
  • +2
15 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 35057355
What kind of a database? What is your experience level? What have you worked with previously?
0
 
LVL 20

Expert Comment

by:hes
ID: 35057876
Do you mean vb 2005.net ?
0
 

Author Comment

by:mahmood_786
ID: 35062832
Yes vb2005.net ,I have no experience data building .
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 96

Expert Comment

by:Bob Learned
ID: 35071334
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
 

Author Comment

by:mahmood_786
ID: 35071688
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
 
LVL 96

Accepted Solution

by:
Bob Learned earned 167 total points
ID: 35071735
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
 
LVL 45

Expert Comment

by:aikimark
ID: 35071761
>>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
 

Author Comment

by:mahmood_786
ID: 35074307
Easy : less coding and easy to understand
0
 

Author Comment

by:mahmood_786
ID: 35090005
How I save and retrieve in vb.net ? Which commands are used and what is the command to delete?
0
 
LVL 45

Expert Comment

by:aikimark
ID: 35090104
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
 

Author Comment

by:mahmood_786
ID: 35090369
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
 
LVL 45

Assisted Solution

by:aikimark
aikimark earned 333 total points
ID: 35090443
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
 

Author Comment

by:mahmood_786
ID: 35090607
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
 
LVL 45

Assisted Solution

by:aikimark
aikimark earned 333 total points
ID: 35094518
@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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
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.…

690 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