Begiiners help with databases

bfsog

Well-known member
Joined
Apr 21, 2005
Messages
50
Location
UK
Programming Experience
5-10
Hey. Can anyone point me to a tutorial, or some source code that shows you

a: how to create a database
b: create a table in that database
c: connect to that database
d: add/edit/delete rows of that table?

I am not knew to Visual Basic, but am new to using databases and .NET

Thanks in advance
 

jmcilhinney

VB.NET Forum Moderator
Staff member
Joined
Aug 17, 2004
Messages
14,338
Location
Sydney, Australia
Programming Experience
10+
Do you want to use Access, MSDE/SQL Server or some other Database? If you want to build a database in code, you will need to learn some (actually a fair bit of) SQL. If you are using Access you can create the database in the Access application. If you are using MSDE/SQL Server, they will integrate into VS.NET through the Server Explorer. As I work mostly with Access, I've only used this method a little and am no expert. Go to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledb.asp for information on the System.Data.OleDb namespace, which you would use to interact with an Access database. There are corresponding classes for interacting with other types of databases too. Go to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/adonetanchor.asp for information on ADO.NET, which is the preferred method of data access for .NET.
 
Top Bottom