HOW TO DELETE ALL RECORDS IN JUST ONE BUTTON IN DATAGRID

[EXTRA_RICE]

HOW CAN I DELETE ALL RECORDS ON A DATAGRID TABLE IN JUST ONE BUTTON..

[rishif2]

try this

Datagrid1.DataSource = Nothing

and also try this

Datagrid1.Clear

hope this helps you . . .

[EXTRA_RICE]

i got an error saying "Method or Data Member not Found!"..huhuhuhu is it possible to delete all the records in just one button?

[Klahr_R]

So you want to delete everything in the DataGrid, (recordset)

Private Sub Delete_cmd_Click
    Do While Not Adodc1.Recordset.EOF
        Adodc1.Recordset.MoveFirst
        Adodc1.Recordset.Delete
        Adodc1.Recordset.Update
        Adodc1.Recordset.MoveNext
    Loop
End Sub

[EXTRA_RICE]

i got an error sir.. pls look at the picture that i uploaded.thanx

[EXTRA_RICE]

its ok and well working sir..thanx a lot!!