datagrid in asp.net

liunx

Guest
Hello ..

I have placed a datagrid on my form and i have placed the following code in the page onload event

Dim strconn As String = "Provider=Microsoft.Jet.OLEDB.4.0;datasource=D:\vb.net\db1.mdb"
Dim strsql As String = "SELECT * FROM cust_details"

Dim dbconn As New OleDb.OleDbConnection(strconn)
Dim cmd As New OleDb.OleDbCommand(strsql, dbconn)
dbconn.Open()
DataGrid1.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection)
DataGrid1.DataBind()

When i run the pgm the following error

"Could not find installable ISAM. "

And its telling me the database is closed.....do i ahve to give any odbc connection and stuff..pls help me

:confused:Your code looks fine.

the issue is not coding, its the access driver..

<!-- m --><a class="postlink" href="http://support.microsoft.com/kb/209805">http://support.microsoft.com/kb/209805</a><!-- m -->

take a look.

-tak
 
Back
Top