vb2005連接數據庫及SQL語法解决办法

vb2005連接數據庫及SQL語法
我現在是自學VB2005但是發現，很多方式都與VB6.0不一樣，像連接數據庫，用SQL語法，都不一樣
望各位大俠給幾個示例
謝謝

[解决办法]
連接數據庫，有ADO,OLEDB,baidu一下就有很多了。至于SQL语法，就是看是什么数据库，语法基本上都相同
[解决办法]
建议查看MSDN,装上vs2005的时候,装上产品文档(MSDN)
[解决办法]

C# code

SqlConnection thisConnection = new SqlConnection(@"Server = (local);Integrated Security = true;database = northwind");            SqlDataAdapter thisAdapter = new SqlDataAdapter(                "SELECT CustomerID ,    ContactName FROM Customers", thisConnection);            DataSet thisDataSet = new DataSet();            thisAdapter.Fill(thisDataSet, "Customers");            foreach (DataRow theRow in thisDataSet.Tables["Customers"].Rows)            {                Console.WriteLine(theRow["CustomerID"] + "\t" + theRow["ContactName"]);                           }            thisConnection.Close();            Console.ReadLine();
[解决办法]
探讨

最好用ado.net 
因为你连sql2000 
所以推荐用system.Data.SqlClient命名空间

[解决办法]
探讨

C# code
SqlConnection thisConnection = new SqlConnection(@"Server = (local);Integrated Security = true;database = northwind");
            SqlDataAdapter thisAdapter = new SqlDataAdapter(
                "SELECT CustomerID ,    ContactName FROM Customers", thisConnection);
            DataSet thisDataSet = new DataSet();
            thisAdapter.Fill(thisDataSet, "Customers");

           …