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
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
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
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