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(ByVa l sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Load
<%@ Import Namespace="Syst em.Data.OleDb"% >

<script runat="server">

sub Page_Load
Dim dbconn, sql, dbcomm, dbread, datasource
dbconn = New sqlDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0")
datasource=" & server.mappath( "conn\userdetai ls.mdb"))
dbconn.Open()
sql = "SELECT * FROM userdetails"
dbcomm = New OleDbCommand(Sq l, dbconn)
dbread = dbcomm.ExecuteR eader()
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]