Connectivity between SQL and ASP.NET

[rajkumarvasan]

Inorder to fetch data from SQL database...i have written the following scripts...but it is showing errors which i am unable to debug..pls help me with this..

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
<%@ Import Namespace="System.Data.OleDb"%>

<script runat="server">

sub Page_Load
Dim dbconn, sql, dbcomm, dbread, datasource
dbconn = New sqlDbConnection("Provider=Microsoft.Jet.OLEDB.4.0" )
datasource=" & server.mappath("conn\userdetails.mdb"))
dbconn.Open()
sql = "SELECT * FROM userdetails"
dbcomm = New OleDbCommand(Sql, dbconn)
dbread = dbcomm.ExecuteReader()
End Sub
</script>
End Class

[Enyi]

What error do you get?

[angsuman chakraborty]

Well, I think if u use sqldata provider then in the connection your provider should be sql connection, not OLEDB.

[Enyi]

Well, I think if u use sqldata provider then in the connection your provider should be sql connection, not OLEDB.

Well spotted, I never noticed. You know ... it could be the other way round :)

[bhar]

Hi,

Note:

When we use a SqlConnectio, you don't have to specify a provider, because the class talks directly to the SQL Server API.

Regards
bhar
[Link Removed]