۱۰-بهمن-۱۳۸۶, ۱۴:۲۲:۳۷
سلام كد زير در قسمت fill كردن مشكل داره و...
Imports System.Data
Imports System.Data.OleDb
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim strconnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\work\old\77\DATA77\77.mdb;"
Dim strsqlforgrid As String = "select * form U77P2"
Dim objconnection As New OleDbConnection(strconnection)
objconnection.Open()
Dim objdataadapter As New OleDbDataAdapter(strsqlforgrid, objconnection)
Dim objdataset As New DataSet
objdataadapter.Fill(objdataset, "U77P2")
DataGrid1.DataSource = objdataset
DataGrid1.DataMember = "U77P2"
objconnection.Close()
objconnection.Dispose()
End Sub
و error زير داده ميشه :
'Error:
An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll
Imports System.Data
Imports System.Data.OleDb
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim strconnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\work\old\77\DATA77\77.mdb;"
Dim strsqlforgrid As String = "select * form U77P2"
Dim objconnection As New OleDbConnection(strconnection)
objconnection.Open()
Dim objdataadapter As New OleDbDataAdapter(strsqlforgrid, objconnection)
Dim objdataset As New DataSet
objdataadapter.Fill(objdataset, "U77P2")
DataGrid1.DataSource = objdataset
DataGrid1.DataMember = "U77P2"
objconnection.Close()
objconnection.Dispose()
End Sub
و error زير داده ميشه :
'Error:
An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll