Hola, Le quiero comentar que no pude hacerlo funcionar con la forma anterior pero dentro de webmatrix hay una funciona para crear las conexiones , Lo que hace el siguiente script es una consulta a la base de datos de deparatmentos y los trae a un control de dropdownlist, les anexo el codigo:
<%@ Page Language="VB" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OLEDB" %>
<script runat="server">
Sub Page_load(Sender as Object, E as EventArgs)
If Not IsPostBack Then
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\Inetpub\wwwroot\ddlBD.mdb"
Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString )
Dim queryString As String = "SELECT [Departaments].[DeptId], [Departaments].[DeptName] FROM [Departaments]"
Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)
ddlDepartaments.DataSource= dataSet
ddlDepartaments.DataBind()
end If
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server" method="POST">
<br />
<br />
<asp:Label id="lblDataSelected" runat="server"></asp:Label>
<br />
<br />
<asp:dropdownlist id="ddlDepartaments" runat="server" datatextfield="DeptName" datavaluefield="DeptID"></asp:dropdownlist>
<br />
<br />
<asp:button id="butok" runat="server" onServerClick="SumbitBtn_Click" text="Enviar" />
</form>
</body>
</html>