请问连接数据库有几种方法？请用程序实现一个访问数据库的方法。

[nice2271]

希望大家帮帮忙，我会给大家加分的。

[chendaiyin]

远程?本地?
ODBC BDE ADO?

[benxie]

ado
dao

[shuchang0626]

ado连接:
首先project->references->microsoft activex data objects 2.7 library
下面是一小段代码
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="数据库文件路径";Persist Security Info=False"
cnn.CursorLocation = adUseClient
cnn.Open
rst.Open "select * from 表", cnn, adOpenStatic, adLockPessimistic

[iainet]

rdo
ado
oledb
ADO.net
下面是它的ado.net联接代码：(本地SQL SERVERL)
imports system.data.sqlclient
Dim cn As SqlConnection
Dim cnstr As String
cnstr = "data source=create;initial catalog=pubs;user id=sa;"
cn = New SqlConnection(cnstr)
cn.Open()