[2005] SQL Codings, Database

[VBLegend]

1. How to use SQL in VB2005 ?
2. Are there installer should i have first ?
3. Or i can code directly ?
4. What is the database should i use ?

[jmcilhinney]

1. Follow the Data Access link in my signature for code examples. Also, there are numerous ADO.NET tutorials available on the Web.
2. To install what?
3. See 1.
4. That's up to you. Access is a good enough option for simple apps if you have Access on your own machine. SQL Server Express or SQL Server CE are other free options, or you can use any other database you like.

[VBLegend]

But most of the company are using SQL so what database should i use ? Logically, its a SQL server but where can i get it specifically how to use them ?

I only have MS SQL Server 2005 > Configuration Tools > SQL Configuration Manager, Error and Usage Reporting, Surface Area Configuration.

[VBLegend]

I found out that MendHak tutorial is very helpful regarding ADO.Net but it is using the MSAccess. But how about SQL i read all the writings of JM but i dont know how to use a SQL Server or SQL Database ?

[dclonch1]

Perhaps a good start would be an intro to the Structured Query Language, as it seems you have very remedial experience with the language itself. Once you begin to understand the language, integrating it with your VB.NET projects is a breeze with ADO.NET. Here is a decent link to an intro to SQL.

http://www.w3schools.com/sql/sql_intro.asp

[GaryMazzone]

Be carefull in what you are assumeing here. SQL is a language not necessarly a database engine. Oracle uses SQL to query the database, modify the database but it is not SQL Server. Same for MySQL, Protige. Microsofts database is SQL Server and it also uses SQL to work with the database. SQL stands for Structured Query Language and it is base on varing degrees of compliance with the ANSI standard for the SQL language. (I think most of the major are in the most part in complience with ANSI 92 Standard)