Salut!
Mon application consiste a affficher tous les enregistrement ou encore de faire une recherche...et jai un bouton modifier pour chaque enr affiché....
j'ai cette erreur....
The SelectCommand property has not been initialized before calling 'Fill'.
pourtant mes variable sont globales.. les voici......
Dim cn As New Odbc.OdbcConnection("DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=C:\Inetpub\wwwroot\annuaire\annuaire.mdb")
Dim ds As New DataSet
Dim da As New Odbc.OdbcDataAdapter
et voici les pricipal fonction....
Private Sub BindData()
da.Fill(ds)
myDatalist.DataSource = ds
myDatalist.DataBind()
End Sub
Sub myDataList_EditCommand(ByVal source As Object, ByVal e As DataListCommandEventArgs) Handles myDatalist.EditCommand
myDatalist.EditItemIndex = e.Item.ItemIndex
BindData()
End Sub
Private Sub cmdRecherche_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdRecherche.Click
Dim requete As String
If RdoNom.Checked Then
requete = "SELECT * FROM personnes WHERE nom LIKE '" & txtRecherche.Text & "%'"
End If
If rdoPrenom.Checked Then
requete = "SELECT * FROM personnes WHERE prenom LIKE '" & txtRecherche.Text & "%'"
End If
If txtRecherche.Text = "" Then
requete = "SELECT * FROM personnes"
End If
Dim cmd As New Odbc.OdbcCommand
cmd.CommandText = requete
cmd.Connection = cn
da.SelectCommand = cmd
da.Fill(ds)
myDatalist.DataSource = ds
myDatalist.DataBind()
txtRecherche.Text = ""
End Sub