Hello
I used the same code to bind to a datagrid.
The code below is working.
Dim Pr_MyCon As System.Data.OleDb.OleDbConnection
Dim Pr_DataSet As DataSet
Dim Pr_DataAdapter As System.Data.OleDb.OleDbDataAdapter
Pr_MyCon = New System.Data.OleDb.OleDbConnection
Pr_DataSet = New DataSet("Temp")
Pr_MyCon.ConnectionString = "Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;User ID=ppr;Initial
Catalog=BMS;Data Source=APHRODITE"
Pr_DataAdapter = New OleDb.OleDbDataAdapter("select * from CUSTOMER",
Pr_MyCon)
Pr_DataAdapter.Fill(Pr_DataSet, "MyTable")
Me.DataGrid1.SetDataBinding(Pr_DataSet, "MyTable")
Regards
Partha
"shachar" <an*******@discussions.microsoft.com> wrote in message
news:1a****************************@phx.gbl...
NO, i copied your code and i get the same error msg.
-----Original Message-----
Hello
You could try this, only you will need to change
Connection string and Tablename
Dim Pr_MyCon As System.Data.OleDb.OleDbConnection
Dim Pr_DataSet As DataSet
Dim Pr_DataAdapter As System.Data.OleDb.OleDbDataAdapter
Pr_MyCon = New System.Data.OleDb.OleDbConnection
Pr_DataSet = New DataSet("Temp")
Pr_MyCon.ConnectionString
= "Provider=SQLOLEDB.1;IntegratedSecurity=SSPI;Persist Security Info=False;User
ID=ppr;InitialCatalog=BMS;Data Source=SERVER1"
Pr_DataAdapter = New OleDb.OleDbDataAdapter("select *
from CUSTOMER",Pr_MyCon)
Pr_DataAdapter.Fill(Pr_DataSet, "MyTable")
Regards
Partha
"shachar" <an*******@discussions.microsoft.com> wrote in
messagenews:28****************************@phx.gbl... hi all(i tried yesterday but it didnt work).
i wrote this code and i get an error msg:
Private Pr_MyCon As System.Data.OleDb.OleDbConnection
Private Pr_DataSet As DataSet
Private Pr_DataAdapter As
System.Data.OleDb.OleDbDataAdapter
Pr_MyCon = New System.Data.OleDb.OleDbConnection
Pr_DataSet = New DataSet("Temp")
Pr_MyCon.ConnectionString = "..."
Pr_DataAdapter = New OleDb.OleDbDataAdapter("select *
from MyTable", Pr_MyCon)
Pr_DataAdapter.Fill(Pr_DataSet, "MyTable")
the error msg saing:"An unhandled exception of
type 'System.Data.OleDb.OleDbException' occurred in
system.data.dll"
.