删除两个表的数据

Question

cmd.CommandText = "select * from staff"

        cmd.Connection = MyConnection

 

        For i = Me.deletedtbase.SelectedRows.Count - 1 To 0 Step -1

 

            cmd.CommandText = "delete from staff where Staff_ID=" & deletedtbase.SelectedRows(i).Cells("Staff_ID").Value

      cmd.CommandText = "delete from login where Staff_ID=" & deletedtbase.SelectedRows(i).Cells("Staff_ID").Value

           

            MyConnection.Open()

            cmd.ExecuteNonQuery()

            MyConnection.Close()

            Me.deletedtbase.Rows.Remove(Me.deletedtbase.SelectedRows(i))

 

        Next

我想要在button1直接删除两个表的数据，该怎样写？上面的代码只能删除一个表的数据。