[rana mohamed12]

i have make adodc connection with access 2007
it is suppose that i wrote the student id in a text then press button search then
the data appear in the data grid

Private Sub Command1_Click()
Adodc2.RecordSource = " select * from Student where StdID = " & Text1.Text & ""

If Adodc2.Recordset.EOF = True Then
MsgBox "Record not found"
Else
DataGrid1.datasource = Adodc2.recordsource
DataGrid1.Refresh
End If
End Sub

there is an error in DataGrid1.datasource = Adodc2.recordsourcei dont know why?

[BobRodes]

You need to set your datasource to the control itself, not to its RecordSource property. adodc.recordsource simply tells the data control where to find its data.

[rana mohamed12]

BobRodes, on 06 July 2012 - 06:14 AM, said:

You need to set your datasource to the control itself, not to its RecordSource property. adodc.recordsource simply tells the data control where to find its data.

thanks a lot