Limpar DatagridView

[AnaGPSI]

Bom dia

Eu preciso de limpar a Datagridview mas já tentei muitas formas e não consigo ..

Alguém me pode ajudar ??

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim abc As String
    abc = Format(DateTimePicker1.Value, "yyyy-MM-dd") & "%"
    Dim abcd As String
    abcd = Format(DateTimePicker2.Value, "yyyy-MM-dd") & "%"
    DataGridView1.Rows.Clear()
    If DateTimePicker1.Text <> "" And DateTimePicker2.Text <> "" Then
	    Dim dt1 As New DataTable

	    Connecttomysql()
	    cmd1.Connection = conn
	    cmd1.CommandText = "SELECT Cod_Abate as Abate, SN, Descricao, Data, Motivo, Autorizacao, Cod_Localizacao as Local, Cod_Equipamento as Equipamento from abate where Data between '" & abc & "' and '" & abcd & "'"
	    dt1.Load(cmd1.ExecuteReader)
	    With DataGridView1
		    .DataSource = dt1
	    End With
	    Disconnectfrommysql()
    End If
    DataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.DisplayedCellsExceptHeaders
    DataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill

   End Sub

[Caça]

DataGridView1.DataSource = Nothing

Edited June 11, 2012 at 08:27 AM by Caça