OleDbDataAdapter

[martialdc]

I use the below but I encouter this error message:

Type 'OleDbDataAdapter1' is not defined'

Dim drsql As New OleDbDataAdapter1("SELECT * FROM employee WHERE empno like '" & TextBox1.Text & "%'"
, OleDbConnection1)
'Dim DataSet11 As New DataSet()
DataSet11.Clear()
drsql.Fill(DataSet11, "Employee")
DataGrid1.DataSource = DataSet11

What code should I write?

[Pirate]

'I think this is what you need . Put this line at the very top of your form .
Imports System.Data.OleDb
 
'or
 
'Use this if you didn't use import directive 
Dim drsql As New Data.OleDb.OleDbDataAdapter